Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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  
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

     

    Hi, I am getting this error.

     

    Thanks