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 ...
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'

     

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!