Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am facing the problem of getting time over 24Hours in the measure field.
Actually I want the sum of time of different people working in 1 day (eg: 13:33:55 + 20:44:23 +15:31:11 + .......)
Thankx
Solved! Go to Solution.
You want to calculate how many hours each employee been working?
Create the below column:
Column = 24-HOUR(Table2[Hourss])
Then, create the below measure:
Measure = CALCULATE(SUM(Table2[Column]),ALLEXCEPT(Table2,Table2[Employee]))
DAX Mode ( In this mode you can agregate for any dimension)
QtSegundos = SUM([Seconds])
Time= VAR Horas = INT([QtSegundos]/3600) VAR Minutos = INT(([QtSegundos] - (Horas * 3600))/60) VAR Segundos = MOD([QtSegundos];60) RETURN Horas&":"&FORMAT(Minutos;"00")&":"&FORMAT(Segundos;"00")
DAX Mode ( In this mode you can agregate for any dimension)
QtSegundos = SUM([Seconds])
Time= VAR Horas = INT([QtSegundos]/3600) VAR Minutos = INT(([QtSegundos] - (Horas * 3600))/60) VAR Segundos = MOD([QtSegundos];60) RETURN Horas&":"&FORMAT(Minutos;"00")&":"&FORMAT(Segundos;"00")
Can you share sample data? I don't think I answered your question 🙂
1st Nov abc 12:32:44
2nd nov abc 14:33:23
3rd Nov abc 13:33:33
1st Nov pqr 20:22:12
2nd nov pqr 16:34;54
3rd Nov pqr 15:46:33
1st Nov mnb 20:52:19
2nd nov mnb 18:34;58
3rd Nov mnb 16:46:37
so now i want the sum of abc(1st, 2nd, 3rd Nov), pqr(1st, 2nd, 3rd Nov), mnb(1st, 2nd, 3rd Nov) resp.
ie: (12:32:44 + 14:33:23 + 13:33:33) of abc of 1st, 2nd & 3rd Nov resp.
Create the below column:
Column = 24-HOUR(Table2[Hourss])
Then, create the below measure:
Measure = CALCULATE(SUM(Table2[Column]),ALLEXCEPT(Table2,Table2[Employee]))
The time is diplaying 00:50:00 where the exact sum of the time is 168:50:00
Thanks.
But the entire field is coming to be 00:00:00
You want to calculate how many hours each employee been working?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |