Knowledge Drop

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

  • 5 April 2021
  • 0 replies
  • 1303 views

Userlevel 5
Badge
  • Looker Staff
  • 171 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!

Reply