Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've got two tables related by ID# (TBL1[ID] *:1 TBL2[ID]) and want to compare the Location column in each table and return a true or false if they match
example:
TBL1
ID Location
1 A
2 B
3 C
TBL2
ID Location
1 D
2 B
3 C
In table 1 I want to add a column that will tell me a True if the location in table 2 for the ID matches the location in table 1 for the ID and a False if it doesn't.
Thanks!
Solved! Go to Solution.
Hi @Niniat
This will create your column
Match = IF(RELATED('TBL2'[Location]) = TBL1[Location] , TRUE, FALSE)
regards
Phil
Proud to be a Super User!
Hi @Niniat
This will create your column
Match = IF(RELATED('TBL2'[Location]) = TBL1[Location] , TRUE, FALSE)
regards
Phil
Proud to be a Super User!
@PhilipTreacy Thank you!! My error was in putting the tables in the wrong order... Thank you so much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |