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.
Hi,
I wanna sum the duration of some activities.
I have a table with activities done by employee during a month.
I wanna make some analyze by activity and employee.
Please find below the database.
https://drive.google.com/drive/u/1/folders/1u-MMDymJQc9uXfpiRiMFfBPhOYQWMCcm
Solved! Go to Solution.
@Alin_Tod , This example have pbix : https://forum.enterprisedna.co/t/time-format-3755-greater-than-24-hours/4733/5
The basic idea it split hr, min and sec add separately as three numbers and combine back
use
Mod for remainder
and quotient for quotient
can you help me solve it? or to keep it active? not solved?
refer if these can help
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
Hi @amitchandak
Thanks for your promt respons.
I was trying to use the formula suggested on the links provided but the results are not ok.
I wanna have eg.:
Name Jan Feb Mar Total
Alin 08:30:00 08:00:00 52:00:00 68:30:00
@Alin_Tod , This example have pbix : https://forum.enterprisedna.co/t/time-format-3755-greater-than-24-hours/4733/5
The basic idea it split hr, min and sec add separately as three numbers and combine back
use
Mod for remainder
and quotient for quotient
can you help me solve it? or to keep it active? not solved?
Unfortunately, I was pressing the button "Accept Solution" insead of reply. I'm not familiar with Power BI. I'm a good one in Tableau. I have the solution there but in Power BI is much more difficult than expected.
I was trying to check the files provided but I cannot see the formulas.
There is another task there. I already have the duration. I do not need it.
I spend to much time on solving this via hundreds of other examples.
Thanks one more time.
I do not know how to unaccept the answer.
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 |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |