How can we exclude the latest date which is available in date column

M_A

I was trying this beastmode formula, and it is giving NULL value for the latest date but when i am putting this formula as filter and selecting this option "Not in" the data shows like "No Data in Filtered Range"

CASE
WHEN Date = MAX(Date) OVER () THEN 'NULL'
ELSE Date
END

MarkSnodgrass

When using the over function, you need to use two aggregations. This should do it:

MAX(MAX(date)) OVER()

M_A

I have also tried with max('date') formula and got the latest date and excluded the same but got the same issue.

MarkSnodgrass

When using the over function, you need to use two aggregations. This should do it:

MAX(MAX(date)) OVER()