EARLIER FUNCTION

[kormosb]

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

[amitchandak · Accepted solution]

Try a new column like

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

[kormosb]

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