Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |