Accumulative total of last year same month

[Asim]

Hello!

dat

I have been facing problem while getting accumulative total of last year same month, I used below mentioned formula to get the accumulative total of previous year but same month,

 LY = CALCULATE([MTD],SAMEPERIODLASTYEAR(Calendar'[Date]))

but this formula is giving me only the total of same period but not the grand total of last year same month.

is there  anyone help me to sort out this issue.

regards

Asi

[LivioLanzo · Accepted solution]

Hi @Asim

as far as I can see you need to use this fomrula: https://msdn.microsoft.com/en-us/query-bi/dax/parallelperiod-function-dax

[LivioLanzo · Accepted solution]

Hi @Asim

as far as I can see you need to use this fomrula: https://msdn.microsoft.com/en-us/query-bi/dax/parallelperiod-function-dax

[Asim · Accepted solution]

This works
Thanks for your help.

Regards
Asim