Forum Discussion
How to extract records value into a cell
Hello All, I have a SharePoint list that has two fields. 1-Project name (Single line of text) 2-Managers (Person or Group> Allow multiple selection>Yes) I imported this into Power BI. At power Q...
Hi Anonymous ,
instead of expanding the column, you can add a new column with this formula:
Text.Combine([Managers][title], ", ")
Greg_Deckler
Community Champion
Community ChampionAnonymous What happens when you use the diverging arrows in the header of Managers, what options do you have?
Hello Greg Deckler,
We are almost there.
It gives me two options:
1-Expand to New Rows
2-Exract Values
The second option(Exract Values) gives error.
However, the first option gives me the list of values. Please see in the screen below.
When I chose the title valu which I am after. Then it works well but it creates extra rows for each value.
However, I want to have those values like this: Column : Manager.title-1, Manager.title-2, etc.
How can I get the data in this way?