Forum Discussion
Solved
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 T...
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~
| 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
Super User
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~