Forum Discussion
DAX FORMULA
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 |
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~
3 Replies
- xifeng_L
Super User
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~
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
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~
