MTD measure to return previous day figures instead of today

[Selded]

Hello All,

Please help with my issue below.

I have a MTD measure that works fine, i want to modify the measure so the result reflects figures as of yesterday and not today.

Measure below

MTD_BCM = TOTALMTD(KPIBudgetForecast[Production Forecast],(Haul[ShiftDate]))

Thank you

[lbendlin · Accepted solution]

Have you tried this one?

MTD_BCM = TOTALMTD(KPIBudgetForecast[Production Forecast],Haul[ShiftDate],Haul[ShiftDate]<TODAY())

[Selded]

@lbendlin 

thank you, it worked.