Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm making a calculated column to check if to columns in different tables are equal. This is the statement I have made but the second table is grayed out.
Location PK = IF(LEFT(Table1[whe],2) = "PK" & Table2[whe] = "PK", "Y","N")
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous ,
If you want to compare two columns, maybe you could try to use the RELATED function. If you want to compare the specific values in the two columns, you could use the LOOKUPVALUE function.
I made two formulas that you can reference.
Note: We need to create a relationship between the tables.
RELATED = IF(RELATED('Table 1'[Name]) = 'Table'[Item],"Yes","No") LOOKUPVALUE = IF(ISBLANK(LOOKUPVALUE('Table'[Item],'Table 1'[Name],"A")), "No", "Yes")
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
Hi @Anonymous ,
If you want to compare two columns, maybe you could try to use the RELATED function. If you want to compare the specific values in the two columns, you could use the LOOKUPVALUE function.
I made two formulas that you can reference.
Note: We need to create a relationship between the tables.
RELATED = IF(RELATED('Table 1'[Name]) = 'Table'[Item],"Yes","No") LOOKUPVALUE = IF(ISBLANK(LOOKUPVALUE('Table'[Item],'Table 1'[Name],"A")), "No", "Yes")
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
hi,
what are you looking for?
which row context are you comparing to which row?
prehaps you can attached an example
regards
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
78 | |
62 | |
61 | |
60 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |