Forum Discussion

kormosb's avatar
kormosb
Helper III
6 years ago
Solved

EARLIER FUNCTION

Hi guys,

 

I am trying to use the earlier function to calculate the dates in the "Refreshed date + 1" table. To sum up, I'd like to get the next day of the refreshed date as I filled it in the alculated column, but it doesn't work.

 

I wonder if anyone can tell me the problem, or any other way to get the expected results.

 

Thanks guys in advance!

Benjamin

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try a new column like

    minx(filter(table,[key]= earlier([key]) && [Refeshed Date]> earlier([Refeshed Date])),[Refeshed Date])

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Try a new column like

    minx(filter(table,[key]= earlier([key]) && [Refeshed Date]> earlier([Refeshed Date])),[Refeshed Date])

    • kormosb's avatar
      kormosb
      Helper III
      6 years ago

      Thanks, its works!:) Although, can you explain what was the problem with my formula?