topic Make columns of difference between columns in two tables in DAX Commands and Tips

Make columns of difference between columns in two tables

Anonymous — Mon, 25 Apr 2022 03:26:34 GMT

I have several files combined using power query. The first table is the data for the base file while the second table is the data for the compared file. The 2 tables are obliged to several universal slicers (applied to both tables coherently). I wish to make a new table comprising two columns, unit difference and unit percentage difference. Any ideas to do this? Thank you.

Re: Make columns of difference between columns in two tables

amitchandak — Mon, 25 Apr 2022 03:59:57 GMT

Anonymous , I think this is similar to what I have discussed here

Compare two Brands: https://youtu.be/exN4nTewgbc

Re: Make columns of difference between columns in two tables

Anonymous — Mon, 25 Apr 2022 06:38:15 GMT

Great video explaining the comparisons. Do you have any code example to calculate the difference of unit as in my situation? I am new in Power Bi, really appreciate any help given. Thank you

Re: Make columns of difference between columns in two tables

amitchandak — Mon, 25 Apr 2022 08:07:27 GMT

Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Please share expected data to check result

Re: Make columns of difference between columns in two tables

Anonymous — Tue, 26 Apr 2022 01:18:29 GMT

https://drive.google.com/drive/folders/1nYQ_Q3p7crChalNrWNdWb7sIdSqhBns9?usp=sharing

Here provided the sample data and pbix. I wish to make a columns of difference only for the dates which both base and compared files have in the same. Thank you

Example output: