Calculate last day of the month

Hello everyone,

I tell you about my problem that could be easy for us. I need to get the last day of the month for example: 01-31-2024 mm/dd/yyyy. It turns out that I usually need to know this date for the current month or the previous one. In Excel there is the EOMONTH() function, does anyone know how I can have this same functionality in Looker Studio?

 

0 2 1,806
2 REPLIES 2

Hi @lcorvera 

Here one of the possible formula: 
DATE(YEAR(Your Date field), MONTH(Your Date field)+1, 0 )

A subset of the following calculated field:

https://how.withlookerstudio.com/calculated-fields/20210118-google-data-studio-calculated-field-rema...

Mehdi

doesn't work anymore