Sum Duration

[Anonymous]

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 

[amitchandak · Accepted solution]

@Anonymous , 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

[amitchandak]

@Anonymous ,

refer if these can help

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax

https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx

[Anonymous]

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

[amitchandak · Accepted solution]

@Anonymous , 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

[Anonymous · Accepted solution]

can you help me solve it? or to keep it active? not solved?

[Anonymous]

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.