Forum Discussion
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 link for excel solution
Thanks in advance
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.
7 Replies
Are you trying to do this in a table, a visual or ? Can you provide more information? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hello Greg
Sorry that i structured it badly. I will try to explain in a better way
Below is the table A
So table A should check for Criteria in Table B (below)
If the criteria matches and the Status is "Verified", it shoud give me data correspoding to marching criteria horizontally (As highlighted in Table A) if status is "not verified" 0 or NA
My idea was to use use LOOKUPVALE, but i dont know how to use in combination (i am a newbee with powerbi)
Thanks in advance
OK, bishnu I'm trying to stick with you here. Can you provide me your expected results from the example data? From what I understand, you for each Criteria in Table A, you want to make sure that the values that appear in Doc1, Doc2, and Doc3 all appear in Table B with a Status of verified, is that close?
