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)
Came to know later that simple below measure will also work
DateDiff in Hours = DATEDIFF(MIN(B),MAX(B),HOUR)