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
mahoneypat
Microsoft Employee
Microsoft EmployeeNot 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
Thank you mahoneypat I think this will open up a new door for my solution.