Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Daniel48
Helper I
Helper I

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

 

 

Table 2

 

Category     Actual 

ABC0001     10.00

 

I have tried doing a lookup and because there are two line with the same category i get errors. I am trying to pull the 10 into the first table so I can do variances such as 11-10 for orginal and 11-10.50 for updated or is there a better way to row compairson 

 

Thank you in advance

 

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

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:

 

relationship.png

 

If you then write this measure 

 

 

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

 

 

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

 

variance.png

 

Regards

 

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
Daniel48
Helper I
Helper I

Thank you it worked !

PhilipTreacy
Super User
Super User

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:

 

relationship.png

 

If you then write this measure 

 

 

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

 

 

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

 

variance.png

 

Regards

 

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.