Disregarding today and yesterday

[#1]

Hi,

I have a chart that has the dimension the months of the year, I need in the current month today and yesterday are disregarded in the calculation, it is possible to do this using Set Analysis or other function? The dimension day, week, etc is avaliable too.

[MK_QSL · Accepted solution]

What you want? MTD, YTD ? What is the measure?

You can have something like below for YTD

SUM({<Date = {">=$(=YearStart(Today()))<=$(=Date(Today()-2))"}>}Amount)

For MTD

SUM({<Date = {">=$(=MonthStart(Today()))<=$(=Date(Today()-2))"}>}Amount)