How to store old data

[Balhemkan]

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

[amitchandak · Accepted solution]

@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-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/