Month to date (MTD) sales up until yesterday for current year

[bvanderwatt]

Good Day 

How can I change the below formula to calculate the sales for this month, but only for completed days? 

The below formula is reading for the previous year. 

MTD NSls LY (Completed days) =

VAR _TODAY = TODAY()

var endLastYear = EDATE(_TODAY,-12) -1

var startLastYear = EOMONTH( _TODAY, -13) + 1

RETURN

CALCULATE(

'Combined Sales'[Sum of Inv+Order],

DATESBETWEEN( 'Calendar'[Date], startLastYear, endLastYear)

)

[v-stephen-msft · Accepted solution]

Hi @bvanderwatt ,

Try this

MTD NSls LY (Completed days) = 
VAR _TODAY = TODAY()
var endLastYear = _TODAY-1
var startLastYear = EOMONTH( _TODAY, -1) + 1
RETURN
CALCULATE(
'Combined Sales'[Sum of Inv+Order],
DATESBETWEEN( 'Calendar'[Date], startLastYear, endLastYear)
)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Coriel-11]

Easiest way is probably just to put a filter on the report chart/page that excludes today.