Forum Discussion

BartVlek's avatar
BartVlek
Helper II
5 years ago
Solved

MTD issue

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
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.