Time between date

Hi admi 

I think you want differance between min time and max time having 0

MEasure=

Var Min_time=Calculate(min(table[Date]),all(table[Date]),filter(table,table[Column]=0))

Var Max_time=Calculate(max(table[Date]),all(table[Date]),filter(table,table[Column]=0))

return

Datediff(Min_time,Max_time,minute)

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

admi 

Is it resolved your problem?

 Sorry, I'm in internship, so i was in school. My problem is not completely resolved. I need to calculate the time when my speed is 0. So here in this case, I need the time from 10:24 to 10:31= 7 min plus the time from 10:36 to 10:40 = 4 min. So a result of 11 min.

Thanks for helping me.

I'm thinking of a simple way of handling this... so you're able to also filter by date. I think utilizing a calculated column to ask IF 0 then 1. Then you can create a measure to sum all of this column.

So try this - 

Create a calculated column within your data table :

Time is Zero = If ( [Speed] = 0, 1 , 0 )

Then create a Measure : 
Total time Zero = SUM ( Time is Zero )

This should create a counter for every instance time = 0. Then you're totaling the counts of 0.

Looks like you have a time stamp for every minute so that should work.