Saving reported results per day in new table

[Anonymous]

Hello,

I created a report to monitor progress for our cycle counting. I want to monitor besides te results also the progress of the count over time (I already have a date table). By every refresh I get actual data form NAV, so the data is not historically fixed. The data of items to be count will change when an item is count in combination with predefined counting periods.

Is it possible to save and fix the results in a new table automatically every day on a predifined moment? With this data I can monitor progress over time.

Any help would be welcome,

Theo

[Seward12533 · Accepted solution]

Not exactly there is no way in PowerBI to write data. If your using service you could have two copies of your data with different incremental refresh settings.

If your incoming data is time stamped wthen you could have measured to calculate your measures over time.

You can do this in EXCEL power pivot with macros.