Forum Discussion

rdallimore's avatar
rdallimore
Frequent Visitor
8 years ago
Solved

Calculated Table

Hi all, hoping some can help me with this one. i have a data extract being pulled from a sharepoint site and from that data i would like to manipluate it so i can use the new format in a PBI Gantt ch...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi rdallimore，

     

    For your case, you may could shape you data by Unpivot column in Query Editor.

     

    Then steps about how to unpivot column, you could have a view of this blog and this video of Unpivot Column in Power BI.

     

    If you need further help, please share some data sample which can reproduce the scenario and your expeced output, so that we can help further investigate on it?

     

    Best, Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi rdallimore，

 

For your case, you may could shape you data by Unpivot column in Query Editor.

 

Then steps about how to unpivot column, you could have a view of this blog and this video of Unpivot Column in Power BI.

 

If you need further help, please share some data sample which can reproduce the scenario and your expeced output, so that we can help further investigate on it?

 

Best, Regards,

Cherry

rdallimore's avatar
rdallimore
Frequent Visitor
8 years ago

Many thanks Cherry, i think this is going to work fine.

 

very much appreicate the help

 

Rich