Forum Discussion
Nick555
Helper I
4 years agoMonthly Data Refresh - Overlay Data
Greetings. I have a monthly process that needs to add the new rolling dataset every month. This process also involves keeping historical data frozen within the data set. Currently the process is:...
amitchandak
Super User
4 years agoNick555 , Refer if DAX append method 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/
- Nick5554 years ago
Helper I
Thanks Amitchandak. It wasn't quite what I needed, however, after reading it and kicking it around with a friend of mine we cobbled something together that might actually work.
- v-easonf-msft4 years ago
Community Support
Hi, Nick555
Could you please tell me whether your problem has been solved?
Best Regards,
Community Support Team _ Eason- Nick5554 years ago
Helper I
It didn't solve the issue at hand. It did lead me down another line of thinking with some other folks that may possibly lead to a solution.
Thx