topic DAX FORMULA in DAX Commands and Tips

DAX FORMULA

Prasanthke — Fri, 22 Nov 2024 14:32:14 GMT

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

Re: DAX FORMULA

xifeng_L — Fri, 22 Nov 2024 16:49:30 GMT

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~

Re: DAX FORMULA

Prasanthke — Fri, 22 Nov 2024 16:56:21 GMT

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

Re: DAX FORMULA

xifeng_L — Fri, 22 Nov 2024 17:24:20 GMT

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~