Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bishnu
Helper II
Helper II

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

https://www.extendoffice.com/documents/excel/2623-excel-vlookup-return-multiple-values-horizontally.... 

Thanks in advance

1 ACCEPTED 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. 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

7 REPLIES 7
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hello Greg

Sorry that i structured it badly. I will try to explain in a better way

Below is the table A

db new.png

So table A should check for Criteria in Table B (below)

db2.png

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?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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. 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors