With the optional sorting step above, if we add dates out of order to the source data, power query will sort by date and return the correct order by date for the running total.
Right click anywhere on the table and choose Refresh to update the table. What happens with the running total when we add or remove rows from our source data? We will need to refresh the power query output table to update the running total with the changes.
