Make columns of difference between columns in two tables

[Anonymous]

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.

[amitchandak]

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

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

[Anonymous]

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

[amitchandak]

@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

[Anonymous]

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: