Comparing two tables and want to display tha updated values and column

[Dev-001]

Hello everyone,

I have two power bi report (201 and 202)within me with column names shipment no, sending agent, transport mode etc. 202 is the updated version of 201. I just wanted to compare two tables and wanted to know the updated values, new and same values and needed to display it. 

Does anyone have worked on such scenario?

Thanks,

[some_bih · Accepted solution]

Hi @Dev-001 if tables are same structure, one option would be to use Power Query type append, check link for example. 

After that create simple measure for your slicing and filtering what you want to analyse for difference in version.

If you need name of file to better understand versioning so you need it, you can use link for adding file name.

[Anonymous · Accepted solution]

Hi @Dev-001 ,

Is [shipment no] unique? I'm assuming the data looks like this:

Please create 3 new measures:

same values = 
VAR __same_records = SELECTCOLUMNS(INTERSECT('201','202'),"shipment_no",'201'[shipment no])
VAR __cur_shipment_no = SELECTEDVALUE('201'[shipment no])
VAR __filter = IF(__cur_shipment_no IN __same_records ,1)
RETURN
__filter

updated values = 
VAR __updated_records = SELECTCOLUMNS(EXCEPT('201','202'),"shipment_no",'201'[shipment no])
VAR __cur_shipment_no = SELECTEDVALUE('201'[shipment no])
VAR __filter = IF(__cur_shipment_no IN __updated_records ,1)
RETURN
    __filter

new values = 
VAR __new_records = EXCEPT(DISTINCT('202'[shipment no]), DISTINCT('201'[shipment no]))
VAR __cur_shipment_no = SELECTEDVALUE('202'[shipment no])
VAR __filter = IF(__cur_shipment_no IN __new_records ,1)
RETURN
__filter

And apply it ti the visual's filter:

Output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum 

[some_bih · Accepted solution]

Hi @Dev-001 if tables are same structure, one option would be to use Power Query type append, check link for example. 

After that create simple measure for your slicing and filtering what you want to analyse for difference in version.

If you need name of file to better understand versioning so you need it, you can use link for adding file name.