Forum Discussion
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 chart.
the initial table is in the following format
| Audit Title | Business Line | Category | IT Involvement | Current Stage | TOR Start | TOR Duration | Field Work Start | FW Duration | Close Out Meeting | Close Out Duration |
| Audit 1 | IT | Client Audit | Lead | Final Report | 01/11/2017 | 7 | 28/02/2018 | 30 | 01/03/2018 | 1 |
I want to create a new table into the following format. each row in the origonal table for each audit would be swapped to represent multiple rows for each task.
| Audit Title | Stage | Duration |
| Audit 1 | TOR Start | 7 |
| Audit 1 | Field Work Start | 30 |
| Audit 1 | Close Out Meeting | 1 |
any help for suggestions would be appreciated
Rich
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
2 Replies
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
Many thanks Cherry, i think this is going to work fine.
very much appreicate the help
Rich
