Set Analysis and Set Expression - actual month

[fhinland_1]

I've created a dashboard with daily-values. I used a trigger, when the .qvw opens select Date as follows 

firstworkdate(today(),3, $(vFeiertage))

I also want to show cumulated values, in this example the sales. If the formula above returns a date like 12.02.2020 i need to get 01.02.2020 till 12.02.2020 in my set expressions/analysis. 

But how to?

[tresesco · Accepted solution]

You can try using MonthStart() like:

">=MonthStart(firstworkdate(today(),3, $(vFeiertage)))   <=firstworkdate(today(),3, $(vFeiertage)) "

[fhinland_1]

Works as joy - many thanks