Forum Discussion
How to store old data
Hello Team,
I have created one dashboard with Data column, User ID and user views.
This will refresh everyday but whenever data refreshed we are not storing old data
example:
We have last 30days data like June 13th to July 13th(refreshed on July 13th)
but if we refresh on July 14th data will change from June 14th to july 14th same way if we refresh on July 15th data will change from June 15th to July 15th.
we are not able to store June 13th data or previous data.
could you please help me how we can store old data going forward even if new day is added.
Thanks,
Balhemkan
Balhemkan , there is DAX append method, You need to make sure you get new data only.
See if these blogs can help
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
1 Reply
Balhemkan , there is DAX append method, You need to make sure you get new data only.
See if these blogs can help
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/