Forum Discussion

lidderdj's avatar
lidderdj
Frequent Visitor
8 years ago
Solved

Table Re-organisations

Hi, 

 

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

 

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

 

 

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

 

 

Need Help
  • anandav's avatar
    anandav
    8 years ago

    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'

     

2 Replies

  • anandav's avatar
    anandav
    Skilled Sharer
    8 years ago

    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'

     

    • lidderdj's avatar
      lidderdj
      Frequent Visitor
      8 years ago

      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!