Forum Discussion

ravi_ch's avatar
ravi_ch
Helper I
4 years ago

How can we calculate dates difference

How can we calculate no. of days between two days like 2/12/2020 - 2/20/2020 = 8,  2/20/2020 - 3/24/2020 = 32 like this
ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

ravi_ch 

you can create a measure

Measure = 
VAR _last=maxx(FILTER(ALL('Table'),'Table'[Date]<max('Table'[Date])),'Table'[Date])
return DATEDIFF(_last,max('Table'[Date]),DAY)