Forum Discussion
Dee
Helper III
Helper IIICompare if value exists on another table based on a column id
Hello, I happen to have two tables where am trying to compare whether the values are the same based on the unique id. example: Table 1 id product value alt1 alt2 aaa oranges 50 60 70 ...
Greg_Deckler
Community Champion
Community ChampionSounds like you need LOOKUPVALUE or a combination of MAXX(FILTER(...)...)
Can this same thing be accomplished in Power Query? ...to see if a record exists in one table and then perform calculation if it does.