Forum Discussion

Likhitha's avatar
Likhitha
Icon for Helper IV rankHelper IV
6 years ago

Doubt regarding about calculating difference between dates

Hello All, I'm having a status column and date column.I need to calculate datediff between preceding dates.How to do that?
Need Help
Show and Tell
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Try this calculated column formula

=[Date]-CALCULATE(MAX(Data[Date]),FILTER(Data,Data[Date]<EARLIER(Data[Date])))

Hope this helps.