Forum Discussion

bishnu's avatar
bishnu
Icon for Helper II rankHelper II
6 years ago
Solved

LOOKUPVALUE And Return Multiple Values Horizontally

Hello Is it possible to stack mutiple values horizontally using LOOKUPVALUE in powerbi. i saw its possible in excel using INDEX, so i tried with SUBSTITUTEWITHINDEX, with no luck following is the l...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    OK, if you do not need them to be in individual columns, you can do this:

     

    Measure = CONCATENATEX(DISTINCT(FILTER('Table',[Status]="verified")),[Code],",")

     

    See attached PBIX file. 

bishnu's avatar
bishnu
Icon for Helper II rankHelper II
6 years ago

Hello Greg

As if now i didnt add index column for both Table A or source data Table B. But i can if its needed

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

OK, if you do not need them to be in individual columns, you can do this:

 

Measure = CONCATENATEX(DISTINCT(FILTER('Table',[Status]="verified")),[Code],",")

 

See attached PBIX file.