Create table of historical totals

[mikeborne]

Hi there

I am using D365 as a sales data source. I am able to sum sales figures and generate live totals, how can I record these totals to get a historical view of the data? The ideal scenario would have the totals automatically recorded on the 1st of each month as a row in a new table.

[v-kelly-msft]

Hi  @mikeborne ,

Check a similar thread below:

https://community.powerbi.com/t5/Desktop/store-historical-data-from-Power-BI-Online/m-p/127700

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!