Forum Discussion
Comparing data: two versions from the same data sources
LoekZ , seems like you want to create a snapshot of data. I think 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/
amitchandak The problem is that in the newest version of the data, the old data is overwritten.
Previous version of data set New version of dataset
Customer Boxes ordered which becomes Customer Boxes ordered
Customer 1 50 Customer 1 40
Customer 2 40 Customer 2 50
Customer 3 30 Customer 3 30
Then I want to see the difference between the ordered amounts.
Customer Difference
Customer 1 -10
Customer 2 +10
Customer 3 0
So no new lines are added to the data. But current data is overwritten. I don't know how to compare these versions