Forum Discussion
Helper VFind matching value in another table and return with text string
Apologies, I'm not understanding this I feel, but if you want to know if there is a match in another table, you could do this:
Column = IF(COUNTROWS(FILTER(ALL('Table2'),'Table2'[Item] = [Item]))>0,"Match",BLANK())
Community ChampionIn general you would use LOOKUPVALUE to do this work or perhaps you could just relate the two tables. I don't think there is enough information presented to truly understand what you are trying to accomplish.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
StuznetSo basically, I need to perform lookupvalue in both tables, if it is the same then return text string "Match"
- Greg_Deckler
Apologies, I'm not understanding this I feel, but if you want to know if there is a match in another table, you could do this:
Column = IF(COUNTROWS(FILTER(ALL('Table2'),'Table2'[Item] = [Item]))>0,"Match",BLANK())- Stuznet
Thank you so much Greg_Deckler.