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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!