The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
88 | |
71 | |
65 |
User | Count |
---|---|
241 | |
124 | |
120 | |
81 | |
79 |