Forum Discussion
Get Date difference with minutes if possible between first occurrence and last occurrence.
In the screenshot attached A has occurred four times and first occurrence is on 01/01/2020 11:20 and last occurrence is 03/01/2020 11:29. So the date difference between these two is 2 days 9 minutes....
Came to know later that simple below measure will also work
DateDiff in Hours = DATEDIFF(MIN(B),MAX(B),HOUR)
amitchandak
Super User
Super UserYou have view data based on column 1
and create a measure to take diff
measure = datediff(Min(Table[Date]),Max(Table[Date]),Minute)