Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
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.
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?
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
29 | |
17 | |
11 | |
9 | |
8 |
User | Count |
---|---|
42 | |
24 | |
21 | |
13 | |
11 |