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 was trying to use IF function to cross check 2 different tables. However it does not work as it is 2 separate tables. Do i really have to merge or append the tables? Below is my formula: Match = If('table A'[template] = 'table B'[template], "Yes", "No")
Solved! Go to Solution.
No you don't have to. You just need to utilize the DAX formula RELATED().
Try to use it like this: Match = If('table A'[template] = RELATED('table B'[template]), "Yes", "No")
Let me know how it goes. I'll also gladly elaborate.
@CTan42,
Please note that when you use RELATED() function as other post, you need to firstly create relationship using template field between the two tables.
Alternatively, merge the two tables based on the template field in query editor, then create Match column in the merged table.
Regards,
Lydia
No you don't have to. You just need to utilize the DAX formula RELATED().
Try to use it like this: Match = If('table A'[template] = RELATED('table B'[template]), "Yes", "No")
Let me know how it goes. I'll also gladly elaborate.
@Anonymous It works. Thanks for your help.
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |