Comparing data: two versions from the same data sources

Question

Hi all,&nbsp;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.&nbsp;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.&nbsp;Could someone help me how to tackle this?&nbsp;

amitchandak · Answer

LoekZ , Check are looking something very similar to 
Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

loekz · Answer

Hi&nbsp;amitchandak&nbsp;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 · Answer

LoekZ , seems like you want to create a snapshot of data. I think DAX append method can help 
&nbsp;
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/

loekz · Answer

amitchandak&nbsp;The problem is that in the newest version of the data, the old data is overwritten.&nbsp;Previous version of data set&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;New version of datasetCustomer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Boxes ordered&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;which becomes&nbsp; &nbsp; &nbsp; &nbsp;Customer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Boxes orderedCustomer 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Customer 1&nbsp; &nbsp; &nbsp; &nbsp; 40Customer 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Customer 2&nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp;Customer 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Customer 3&nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp;Then I want to see the difference between the ordered amounts.Customer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DifferenceCustomer 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Customer 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; +10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Customer 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;So no new lines are added to the data. But current data is overwritten. I don't know how to compare these versions

Forum Discussion

Comparing data: two versions from the same data sources

4 Replies

Related content

Version control

Data source

Development (Version Control, Solution, Source, Publish) Governance Framework

compare source to destination

Source / Version Control for PBIX files