Forum Discussion

Adham's avatar
Adham
Helper III
6 years ago

Calculate time between dates for each unique identifier

Hello All,   I have been stuck with this issue for a while and i would appreciate some help. I have got the following table.   ID Date 1 16/07/2020 14:11:12 1 17/07/2020 15:12:11 1...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi  Adham ,

 

Yes,change the measure into calculated column :

_Time = 
var _mindate=CALCULATE(MIN('Table'[Date]),FILTER('Table','Table'[ID]=EARLIER('Table'[ID])))
var _daydiff=DATEDIFF(_mindate,'Table'[Date],HOUR)
Return
_daydiff&":"&FORMAT('Table'[Date]-_mindate,"nn:ss")

For modified .pbix file,pls see attached.

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!