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...

ChelsieEidensDuration.pbix145 KB

Other

Time Intelligence

Totals

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

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.