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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.