Forum Discussion

Daniel48's avatar
Daniel48
Icon for Helper I rankHelper I
2 years ago
Solved

Cross Comparison Between Tables

Hello      I am trying to do line by line comparison of categories between tables    Table 1   Category   budget        ABC0001   Orginal           11.00 ABC0001   Updated         10.50   ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi Daniel48 

     

    Download example PBIX file with the example below

     

    If you enter both tables into PBI, it should create a 1 to many relationship between the tables, based on the Category:

     

     

    If you then write this measure 

     

     

    Variance = MAX('TableA'[Value]) - MAX('TableB'[Actual])

     

     

    and put that into a table visual, you'll get this

     

     

    Regards

     

    Phil

     

Daniel48's avatar
Daniel48
Icon for Helper I rankHelper I
2 years ago

Thank you it worked !