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...
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.

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.