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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Dersim
Helper I
Helper I

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 @Dersim ,

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

@Dersim 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 @Dersim ,

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

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

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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.