Time Different in the same column

[Anonymous]

Hi All,

How I can get the time different for time_tz column between each row (in the same column) using DAX

[Greg_Deckler]

See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...

[amitchandak]

@Anonymous , Try like

Diff = datediff(maxx(filter(Table, [time_tz]<earlier([[time_tz]])),[time_tz]),[time_tz],hour)

Or add the subgroups
Diff = datediff(maxx(filter(Table, [time_tz]<earlier([[time_tz]]) && [device_name]<earlier([[device_name]])),[time_tz]),[time_tz],hour)

change unit of time hour as per need

[Anonymous]

Hi, I am getting this error.

Thanks