Forum Discussion
Time Different in the same column
Hi All,
How I can get the time different for time_tz column between each row (in the same column) using DAX
3 Replies
- amitchandak
Super User
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
- Greg_Deckler
Community Champion
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/339586
