Forum Discussion
Comparing data: two versions from the same data sources
Hi amitchandak
Thanks for replying! It is clear how to compare the data.
However i don't know how to get 2 versions of data from the same data source.
I need two versions of the data from the same data source, but i don't know how to load these into my PowerBI report.
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
