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

Get 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

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. 



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

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



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

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?



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

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?



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

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. 



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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