The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
User | Count |
---|---|
87 | |
84 | |
36 | |
35 | |
30 |
User | Count |
---|---|
95 | |
74 | |
67 | |
52 | |
51 |