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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
zjaff69
New Member

Multiple values in row or cell

Hi 

 

I have multiple values in one row and am not able to do it. Please see the below data. 

 

Users          Groups

John           Everyone
                   Finance
                   Warehouse
                   Stores

Scott           Everyone
                   Finance
                   Warehouse
                   Stores

 

I want to get the result below.

 

Users        Groups

John          Everyone
John          Finance
John          Warehouse
John          Stores

 

Can you please help me? I was trying to group all users. I have many users in the finance group. It just an example when I group finance, I can get a count 2 user

 

Thanks

 

 

 

1 ACCEPTED SOLUTION
JirkaZ
Solution Specialist
Solution Specialist

Ah ok - then you'll have to use Split column by delimiter (in Power Query) and you have to choose/type #lf (line feed) as a delimiter

 

JirkaZ_0-1675973857106.png

 

View solution in original post

4 REPLIES 4
zjaff69
New Member

Thanks for your reply, User and group is one row, but the second column has multiple group names in the row. i did not get how I can do this.

 

users.PNG

JirkaZ
Solution Specialist
Solution Specialist

Ah ok - then you'll have to use Split column by delimiter (in Power Query) and you have to choose/type #lf (line feed) as a delimiter

 

JirkaZ_0-1675973857106.png

 

Thanks, It worked!!

JirkaZ
Solution Specialist
Solution Specialist

You can use the Fill Down transformation in Power Query. Note that you have to replace the blank values in the Users column with "null". Without that first step the "Fill Down" will not work.

 

JirkaZ_1-1675969746969.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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