Calculate the Difference between two tables

[Anonymous]

Hello all,

In my report I want to compare two tables to each other. They both include the same columns with the same names, but the values in the rows differ.

Until now I did it by creating a separate Measure for every column but I was wondering if there is a easier way to do it. 

Any help would be very much appreciated.

Regards,

Jakob

[Anonymous]

Hi @Anonymous ,

If your data volume is not large, you can try Append or Merge operations.

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jppv20]

Hi @Anonymous ,

Please share some example data and expected output