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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

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 Query Editor:

Under the Manger column I see two list items as shown on the screenshot-1 below.

When I click on a list, I see 2 records as shown on the screenshot-2 below.

When I click on a record, I see all data that relevant to that record. Please see the attached screenshot-3

My question is this:

I want display those records’ (right now there are two records however there can be more than two records) value in a column like this:

Column:

title1, title2, title3 so on….

How can I achieve this?

Thank you for your support in advanced.

Screen-1.png.

Screen-2.png

 

Screen-3.png

 

Screen-4.png

1 ACCEPTED SOLUTION

Hi @Anonymous ,

instead of expanding the column, you can add a new column with this formula:

 

Text.Combine([Managers][title], ", ")

 

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

@Anonymous I can never remember that one. @edhans @ImkeF 



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...

Hi @Anonymous ,

instead of expanding the column, you can add a new column with this formula:

 

Text.Combine([Managers][title], ", ")

 

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Greg_Deckler
Super User
Super User

@Anonymous What happens when you use the diverging arrows in the header of Managers, what options do you have?



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...
Anonymous
Not applicable

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.

Screen-5.png

 

Screen-6.png

 

How can I get the data in this way?

Screen-7.png

 

 

Helpful resources

Announcements
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!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.