Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |