Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Using the Lookupvalue formula and both ways relationship

I am using the below formula to compare 2 columns on seperate tables. And it works great, it gives me the exact result I want.

 

Match = IF(ISBLANK(LOOKUPVALUE('DB Formatted'[WorkOrder],'DB Formatted'[WorkOrder],TimeCard[WO])) , "No Match",
"Match"
)
 
This gives me a column that goes through both columns and shows which items have a "Match" on the other column and which ones don't and I am able to filter and it is great.
 
I have four tables that are linked to a bridge. One of these tables has a both ways relationship with the bridge, as that table is what drives everything else. When this both ways relationship is applied, the "No Match" filter goes away and only the "Match" is showing.