Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@Nialpel0689 When you click the diverging arrows, select Extract Values instead of Expand to Rows.
@Nialpel0689 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!
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 :
Any idea on how to include the comma between values?
Sorry, of course this should be
each Text.Combine([Trainings and certifications], ", ")