Can I use Table Calculations to show total number of days in a month?

[LookerExperts]

Knowledge Drop

Last tested: Feb 18, 2018
 

Yes, we can do that in Table Calculations.  Given a date dimension ${date}, this calc returns the number of days in the month of ${date}.

extract_days(add_days(-1, date(extract_years(add_months(1, ${date})), extract_months(add_months(1, ${date})), 1)))

This content is subject to limited support.