Forum Discussion
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...
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!
Would it be possible to also show me the power query version of this? I want to change the type to duration, then hopefully be able to plot it on a line graph as continuous. Currently i can only plot it as categorical as this is done in dax.