Need measure for MTD up to Prior Day

[ERing]

I have a requirement to show [Total_Sales] for the current month up to the Prior Day. My report will not have a date slicer or any Date context in the visuals.

For example, today is May 12th, 2025. I need the measure to show [Total_Sales] from May 1st, 2025 - May 11, 2025. When we reach May 18th, 2025, the measure should show [Total_Sales] between May 1st, 2025 - May 17th, 2025.

[techies · Accepted solution]

Hi @ERing As i understand, MTD value up to yesterday, please check this measure

MTD Total Sales - Up to Prior Day =

VAR TodayDate = TODAY()

VAR Monthstart = DATE(YEAR(TodayDate), MONTH(TodayDate), 1)

VAR EndDate = TodayDate - 1

RETURN

CALCULATE(

    SUM('cases'[Value]),

    DATESBETWEEN(

        'Date'[Date],

        Monthstart,

        EndDate

    )

)

[ERing]

@techies 

Yes, this appears to be working.  And just to confirm, this will adjust with new months into the future, correct? For example, when we reach June 2, this will provide data for June 1?

[techies]

yes