Forum Discussion
LOOKUPVALUE And Return Multiple Values Horizontally
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.
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?
Hello greg
Thank you
The expected results are highlighted in green for Doc1, Doc2, and Doc3 in table A. I didnt know how to do it, so i entered it manually so that i what i wants as my result.
So basically the table B status will change, say like "N\A, Not verified, or Verified" but obviously final result will be "Verified".
I am trying to create this table A in powerbi so that i can keep a track of "N\A, Not verified, or Verified" doc's(documents) corresponding to each criteria.
i didnt understand what you meant by close!
Regards
B
OK, do you have an Index column for your source data table or can you add one?
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
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.