How I can get the time different for time_tz column between each row (in the same column) using DAX
@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
Proud to be a Super User!
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...
Hi, I am getting this error.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.