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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
TexasXD1
New Member

Creating new rows in dataset based on other columns

I have a dataset that contains the below. I would like to create new rows for each record that are based on values in existing columns. Is this possible?

 

Example:

 

Before:

TexasXD1_0-1712243206251.png

 

 

After:

TexasXD1_2-1712243260560.png

 

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

That looks like : select userid column and 'Unpivot other columns' in Power Query

View solution in original post

2 REPLIES 2
HotChilli
Super User
Super User

That looks like : select userid column and 'Unpivot other columns' in Power Query

That looks to have done it. I was trying to unpivot without remembering the dropdown to change the way it does it. Thanks!

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

Top Solution Authors
Top Kudoed Authors