Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Chelsie Eiden's Duration

Chelsie Eiden is my new favorite human being on the face of the planet. I don't know her major but, even if she is majoring in math, it still wouldn't change my mind on this one. That's how much I li...
Other
Time Intelligence
Totals
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Greg.

It's working as expected and it resolved the issues in my report.

 

Thank you so much for your help.

 

Regards,

Umasankar

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi all

     

    Not going to suggest I 100% understand this, been working blind on Power Bi and came across this whilst lookingn to sum time to be more than 24:00:00. 

     

    This issue I have with this is that I want to use this to calculate the number of working hours based on a number of days, i.e 07:00:00 * 7 should be 49:00:00. 

     

    Due to the data, I have had to create a column called Working Hours, this figure is repeated against each action so I am having to use the average of that column against the number of days....with me so far? Not sure I am. 

     

    Anywho, when changing the Sum([Duration]) to Average([Working Hours])*{Days]

     

    The rest remains the same however I get results such as 08:45:00 * 5 = 7.00 rather than 43:45:00

     

    Anyone able to point me in the right direction here? Much appreciated.