How can I get the amount of time between these events?

[Dave_C]

I have a table that tracks different status's.  I have created date and times, for each event.  I need to know how to get the amount of time between events.  

[v-cherch-msft]

Hi @Dave_C 

You may create measures like below.

Last_event_date = CALCULATE(MAX('Table1'[Date]),FILTER(ALL('Table1'),'Table1'[Index]=MAX('Table1'[Index])-1))

Measure = DATEDIFF([Last_event_date],MAX(Table1[Date]),HOUR)

Regards,

[Dave_C]

This is the query that the my coder has built to get data into his world, but we need to get this up to the Power BI system to use.

This needs to be in a direct query model if at all posible