Forum Discussion

atacuboy's avatar
atacuboy
Frequent Visitor
5 years ago
Solved

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...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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/

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

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's avatar
atacuboy
Frequent Visitor
5 years ago

Thank you so much!