Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
atacuboy
Frequent Visitor

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

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?

 

DatePrevious DateDifference
June 18, 2020--
November 15, 2020June 18, 2020150
March 2, 2021November 18, 2020107
1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @atacuboy 

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

 

Picture5.png

 

 

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/

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


Go to My LinkedIn Page


View solution in original post

4 REPLIES 4
Jihwan_Kim
Super User
Super User

Hi, @atacuboy 

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

 

Picture5.png

 

 

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/

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


Go to My LinkedIn Page


Thank you so much!

amitchandak
Super User
Super User

@atacuboy , Create a new column like

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

Thank you also for replying!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.