Help in making pivot table in power bi

[iksaum]

I have a table as follows:

I needt to make it like this:

Work Utilization	Hours	As per Mandated Hours	As per Available Hours
Self - Core Utilization	276.5	65%	100%
Other - Core Utilization	0	0%
Self - Contingency Utilization %	0	0%
Other - Contingency %	0	0%
Total Utilization		65%	100%

PLease help!!

[v-juanli-msft]

Hi @iksaum 

I don't know how to get the "hours", "As per Mandated Hours" from provided information?

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[iksaum]

Work Utilization	Hours	%(Mandated Hours)	%(Actual Hours)
Self - Core Utilization	276.5	65%	100%
Other - Core Utilization	0	0%
Self - Contingency Utilization	0	0%
Other - Contingency	0	0%
Total Utilization		65%	100%

i hope the above table makes it clear.

If it doesn't, heres and explanation:

Self - Core Utilization, Other - Core Utilization, Self - Contingency Utilization, Other - Contingency Utilization are 4 measures i have created with their percentage values. All these values are in hours. Accordingly their percentages are calculated (as per actual hours and as per mandated hours)

The above table is from an excel sheet. I need such a table in power bi.

Kindly help!

Regards,

Saumitra Upadhyay