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?
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:
doesn't work anymore
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |