Return Previous Date or Calculate Difference from Previous Date in Earlier Row

[atacuboy]

Hello Everyone,

I'm trying to get the difference between the date at the current row and the date from a previous row, similar to the table below. 

Would any of you know how to create the column in red font below?

Date	Previous Date	Difference
June 18, 2020	-	-
November 15, 2020	June 18, 2020	150
March 2, 2021	November 18, 2020	107

[Jihwan_Kim · Accepted solution]

Hi, @atacuboy 

If you are looking for creating a column, try something like below.

previous date column =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER ( 'Table', 'Table'[Date] < EARLIER ( 'Table'[Date] ) )
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[atacuboy]

Thank you so much!

[amitchandak]

@atacuboy , Create a new column like

datediff([Date], maxx(table, [Date] < earlier([Date]),[Date]), day)

[atacuboy]

Thank you also for replying!