Comparing data: two versions from the same data sources

[LoekZ]

Hi all,

I want to make a new PowerBI, where two versions of data from the same datasource (data of salesorders) are compared.

The goal is to see the difference between the old salesorders and the updated salesorders for the same customer.

For this i need the same data twice (so the same datasource is used). One which was refreshed before the update came in, one version where the updated salesorder is in.

So it should also be possible to refresh only one version of the same data, when just an updated salesorder came in.

Could someone help me how to tackle this? 

[LoekZ]

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.

[amitchandak]

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

[LoekZ]

@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

[amitchandak]

@LoekZ , Check are looking something very similar to

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc