Calculated Table

[rdallimore]

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

[v-piga-msft · Accepted 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

[rdallimore]

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

very much appreicate the help

Rich