Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

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

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)
)
1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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.

Resolver I

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

## Helpful resources

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors