Google Data Studio calculated field – Remaining number of days until the end of the month

The Google Data Studio calculated field below returns the remaining number of days until the end of the month of a specific date.



Remaining days until the end of the month
DATE_DIFF(
   DATE(YEAR(Date), MONTH(Date)+1, 0 )
   ,
   Date
)


  • Explanations of the formula step by step
    1. Create a date (line 2) using
      – the year of the date,
      – the month after the month of the date,
      – 0 as day to get the day just before the first day of the month
    2. Calculate the difference between the result of the 1st step and your date dimension
  • Input
    • Any date dimension with date type
  • Output
    • The remaining number of days until the end of the month of the date
  • Used functions
Share