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~
xifeng_L
Super User
Super UserHi 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~