Forum Discussion
Sum Duration
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
can you help me solve it? or to keep it active? not solved?
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
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
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.
can you help me solve it? or to keep it active? not solved?