How to add hours in power bi using DAX measurements

[evega]

I have recently developed a measure in a context where filters are used to add up the total hours, but the result is not correct. 

 

[evega]

Me ha funcionado, muchas gracias!!!  @TeoC

 

[TheoC · Accepted solution]

Hi @evega, 

Add this as a Calculated Column:

Total Time = 

VAR _TotalHours = INT ( LEFT ( Table[Horas] , 2 ) )
VAR _TotalMinutes = INT ( RIGHT ( Table[Horas] , 2 ) )

RETURN 

_TotalHours + (_TotalMinutes / 60 )

Below is a screenshot of the output.  Hope this helps! 🙂

[evega]

Hi  @TeoC

It won't allow me.

 

[TheoC]

@evega what Data Type is your Horas column?

[evega]

The data type is time, but I'll try to switch to text

[TheoC]

Hi @evega, that would be good if you could convert to text. Alternatively, I am happy to adjust to get you the output required.