sum of hours date

[belenjave]

hi! I am trying to sumarize the difference between two columns wuth dates..the result is in a hours/minutes format.

When a want to do the grafic, do not allow me tue operation of sum, only "count".. i know is a format problem, but a dont know how i have to do it.

Tks in advance for the answer..

 

[Anonymous · Accepted solution]

Hi @belenjave,

Power bi not support do mathematical functions to calculate with date/time value.

You need to convert to time value to total second or other similar numeric type to calculate and transform to original type after finish calculation.

Aggregating Duration/Time

Regards,

Xiaoxin Sheng