DAX FORMULA

[Prasanthke]

How to create the calculated columns like break, production which contains only break time, production using the below mentioned data against each user.

User Name	Task Type	Actual Handling Time (min)
anandhu.krishna.v.s	Production	32.1667
anandhu.krishna.v.s	OtherProductive	30.5
anandhu.krishna.v.s	Break	30
anandhu.krishna.v.s	Break	30
anandhu.krishna.v.s	Production	448.2167
prasanth.k.e	Production	300.9833
prasanth.k.e	Production	187.1833
prasanth.k.e	Production	0.2
prasanth.k.e	Break	60.45
prasanth.k.e	OtherProductive	18

[Prasanthke]

User Name	Production	OtherProductive	Break
anandhu.krishna.v.s	480.3834	30.5	60
prasanth.k.e	488.1666	18	60.5

I need to have data in the above format in the calculated columns

[xifeng_L · Accepted solution]

Calculated columns don't achieve this effect, you can instead use PowerQuery's pivot function to achieve it. 

For example:

Then get the result you want.

Finally, just load into PowerBI.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[xifeng_L]

Hi @Prasanthke ,

Is this what you wanted?

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~