cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lidderdj
Frequent Visitor

Table Re-organisations

Hi, 

 

I have a table with the following data (amongst others):

PBI1.jpg

 

I'd like to create a new table from these columns with the following format:

PBI2.jpg

 

 

I'm at a complete loss about how to achieve this, so any assistance woulfd be greatly apreciated.         

 

 

1 ACCEPTED SOLUTION
anandav
Skilled Sharer
Skilled Sharer

@lidderdj,

 

You will need to use the Unpivot functionality in Power BI.

 

In Query Editor you will select the ID column and from 'Tranform' tab select 'Unpivot Columns' --> 'Unpivot Other Columns'

 

Sample.jpg

View solution in original post

2 REPLIES 2
anandav
Skilled Sharer
Skilled Sharer

@lidderdj,

 

You will need to use the Unpivot functionality in Power BI.

 

In Query Editor you will select the ID column and from 'Tranform' tab select 'Unpivot Columns' --> 'Unpivot Other Columns'

 

Sample.jpg

View solution in original post

lidderdj
Frequent Visitor

Brilliant. Thank you so much for your swift reply! That's a really elegant solution for something I've been trying to write a DAX code for! 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors