Forum Discussion
VLOOKUP in DAX
Hello folks, I am kinda struggling past 2 days for a solution. I have data that was working fine with LOOKUPVALUE function but now the data is updated and 1 variable has multiple rows as outpu...
Not totally clear on how you are using the result, but this measure expression may work. This assumes the ID column is numeric. If not, wrap it in quotes like "101".
MatchingValues = var vMatches = CALCULATETABLE(VALUES(Table[Col1]), Table[ID]=101)
return CONCATENATEX(vMatches, Table[Col1], ", ")
Pat
Ashish_Mathur
Super User
Super UserHi,
Since in Table1 there are no repetitions in Col 1, the LOOKUPVALUE() function in Table2 should work just fine.