cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nialpel0689
Regular Visitor

Extract multiple values from List (no "name" field available like shown on other examples)

Hi, 

 

I have tried to look up for other similar posts but I couldnt find an appropriate solution to my issue, this is why I am creating a new post, hoping I can get some support. 

 

I have a column in my Power BI, extracted from a SharePoint multiple choice column online list, that is composed of list items: 

Nialpel0689_0-1663796575286.png

When I click on the "List" , it show me this: 

Nialpel0689_1-1663796615051.png

The values from the multiple choice column the user has selected and their relevant indexes. 

 

I want to extract those values (all) and get them in one row. 

 

I found this formula and I have tried it with a costum column but it gives me only one value relevant to the index: 

= Table.AddColumn(#"Removed Columns1", "Custom", each [Trainings and certifications]{1})

Nialpel0689_2-1663796771445.png

I have tried to apply an array of indexes to get all the values but I couldnt figure out the proper way I suppose, it was showing me an error. 

 

I would greatly appreciate help on this, 

 

Thank you very much in advance.

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Nialpel0689 When you click the diverging arrows, select Extract Values instead of Expand to Rows. 


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

6 REPLIES 6
Greg_Deckler
Super User
Super User

@Nialpel0689 When you click the diverging arrows, select Extract Values instead of Expand to Rows. 


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler  Thank you very much! it's perfect , no need coding - the "diverging arrows" button is pretty amazing ! I didnt even notice it before you have mentioned it , thank you so much! 

jbwtp
Memorable Member
Memorable Member

Hi @Nialpel0689,

 

I think you may need to do omething like:

each Text.Combine([Trainings and certifications]) rather then each [Trainings and certifications]{1}

This creates a string of all values separated by comma. Is this what you mean by get them in one row?

 

Cheers,

John

@jbwtp  Yes! that's it, it works. 
I have them all in one row 🙂 however they are not separated with comma... 

It shows me this : 

Nialpel0689_0-1663798103199.png

 

Any idea on how to include the comma between values?  

Sorry, of course this should be 
each Text.Combine([Trainings and certifications], ", ") 

@jbwtp  thank you very much! Its great 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors