Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have the ActualLabourMinutes that need to be converted into Hours.. I have created a column that is called Labour Hours however its applying the total hours across all rows instead of sum of individual rows. The output column should be ActualLabourHours which I need help to create?
I used the follow - LabourHours = CALCULATE(SUMX(WorksOrderTracking,WorksOrderTracking[ActLabourMinutes])/60
ActualLabour
Minutes LabourHours ActualLabourHours
2942 337.4333333 49.03333333
982 337.4333333 16.36666667
4038 337.4333333 67.3
2707 337.4333333 45.11666667
1641 337.4333333 27.35
872 337.4333333 14.53333333
3305 337.4333333 55.08333333
296 337.4333333 4.933333333
3463 337.4333333 57.71666667
20246 3036.9 337.4333333
Solved! Go to Solution.
Hello @PSRai,
Please try the following DAX query in your calculated column query:
LabourHours = WorksOrderTracking[ActLabourMinutes]/60
Let me know if this works.
Create a new column ,
LabourHours =WorksOrderTracking[ActLabourMinutes]/60
Create a new column ,
LabourHours =WorksOrderTracking[ActLabourMinutes]/60
Hello @PSRai,
Please try the following DAX query in your calculated column query:
LabourHours = WorksOrderTracking[ActLabourMinutes]/60
Let me know if this works.
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |