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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.