Knowledge Drop

How to calculate and filter on last day of month (EOM)

  • 5 April 2021
  • 0 replies

Userlevel 5
  • Looker Staff
  • 172 replies

Last tested: June 2020

This can be done with custom filters:

extract_days(add_days(1,${date})) = 1

The logic is “tomorrow’s day of month is 1”. That is, the day after the last day of the month will always be the 1st of a month.


This content is subject to limited support.                

0 replies

Be the first to reply!