MTD issue

[BartVlek]

Hi,

If my formula for MTD is 

MTD_ASD = CALCULATE(SUM('DAGOMZET-ASD'[ASD_OMZET_EX_BTW]),MONTH('DAGOMZET-ASD'[DATUM])=MONTH(TODAY()),YEAR('DAGOMZET-ASD'[DATUM])=YEAR(TODAY()))

What formula do I use for the MTD in the previous year?

Thanks,

Bart

[Anonymous · Accepted solution]

Try add another SAMEPERIODLASTYEAR function in the filter expression.

MTD_ASD = CALCULATE(SUM('DAGOMZET-ASD'[ASD_OMZET_EX_BTW]),MONTH('DAGOMZET-ASD'[DATUM])=MONTH(TODAY()),YEAR('DAGOMZET-ASD'[DATUM])=YEAR(TODAY()), 
SAMEPERIODLASTYEAR([DATUM]))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.