Forum Discussion
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:
When I click on the "List" , it show me this:
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})
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.
Anonymous When you click the diverging arrows, select Extract Values instead of Expand to Rows.
6 Replies
jbwtpMemorable Member
Hi Anonymous,
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
- Greg_Deckler
Community Champion
Anonymous When you click the diverging arrows, select Extract Values instead of Expand to Rows.
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!