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

M_A · 2024-07-12T11:01:42+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

MarkSnodgrass

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

MAX(MAX(date)) OVER()

All comments

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()

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of