Only days of current month in sum

[reporting_neu]

Hello, I am looking for a correct formula.

I need the sum of the individual days of the current month.

I have a date as a dimension. I added the following formula to the metric to test the month of May:

{<[DATE] ={">=$(=date(addmonths(MonthStart(Today()),-1))) <=$(=date(addmonths(MonthEnd(Today()),-1)))"}

In the case of the dimension, I only see days from May. However, no value for May 31st. But there is definitely one in the database. The problem seems to be with all months with 31 days.

Can you help me change the formula accordingly and, if it works, change it to the current month?

Johannes

[MayilVahanan · Accepted solution]

HI @reporting_neu 

Try like below

{<[DATE] ={">=$(=date(MonthStart(Today(),-1))) <=$(=date(MonthEnd(Today(),-1)))"}>}

[reporting_neu]

The solution was that close. Many Thanks!