topic How can you create a column that shows the days between Dates? in DAX Commands and Tips

How can you create a column that shows the days between Dates?

Anonymous — Thu, 13 Aug 2020 14:17:15 GMT

Hello all,

How can I create a column that shows me how many days have passed between diffrent dates?

Dates	Day Between
Monday, 3. Aug 2020
Friday, 31. Jul 2020	3
Thursday, 30. Jul 2020	1
Monday, 20. Jul 2020	10
Tuesday, 14. Jul 2020	6

Thank you in advance for your time.

Re: How can you create a column that shows the days between Dates?

HotChilli — Thu, 13 Aug 2020 15:03:48 GMT

ColumnB = VAR _theDate = TableD[Dates] VAR _1higherDate = MINX(FILTER(TableD, TableD[Dates] > _theDate), TableD[Dates] ) RETURN DATEDIFF( _theDate, _1higherDate, DAY)

Re: How can you create a column that shows the days between Dates?

amitchandak — Thu, 13 Aug 2020 15:46:32 GMT

Anonymous , try a new column like

datediff([dates], minx(filter(table, [dates]>earlier[dates]),[dates]),day)

Re: How can you create a column that shows the days between Dates?

Anonymous — Sat, 15 Aug 2020 17:40:23 GMT

Hi Anonymous ,

Incase you want a measure

Dates B = var a = MAX(Table1[Date]) var _prevdate = CALCULATE(MAX(Table1[Date]) , FILTER(ALL(Table1),Table1[Date] < a)) RETURN DATEDIFF(_prevdate,a,DAY)

Incase you want a Column

Prev Date = var _prevdate = CALCULATE(MAX(Table1[Date]) , FILTER(Table1,Table1[Date] < EARLIER(Table1[Date]))) RETURN DATEDIFF(_prevdate,Table1[Date],DAY)

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!