Forum Discussion

EpicTriffid's avatar
EpicTriffid
Helper IV
6 years ago

Lookup from multiple values in same column

Hi all,   Stumped on this one and need some help.   I'm trying to concatenate ID numbers based on combinations of units they can take. This is all currently in one table.   So, we have this kin...
Need Help
Tips and Tricks
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Perhaps:

IDs =
  IDs1 = CONCATENATEX(FILTER('Units','Units'[Unit] = [Comb1]),[ID],", ")
  IDs2 = CONCATENATEX(FILTER('Units','Units'[Unit] = [Comb2]),[ID],", ")
RETURN
  IDs1 & ", " IDs2