How to calculate the sales same period 2 years but month.

[RenataOGardner]

Hi guys,

I'm trying to calculate the sales of the same period but 2 years ago.

I have tried the below, but it didn't work.

Many thanks!

[negi007 · Accepted solution]

@RenataOGardner You can create a measure like below

CALCULATE(SUM('Net Sales TY'),PARALLELPERIOD('Date'[Date],-2,YEAR))

first part is the sum of your value and second part is the date filter in the above dax. i hope this works for you.

[sayaliredij]

Hi @RenataOGardner 

You can try following formula

Sales SamePeriod2Years = 

CALCULATE (
SUM(Sales[Net Price]),
DATEADD ('Date'[Date],-2,YEAR )
)

Regards,

Sayali

If this post helps, then please consider Accept it as the solution to help others find it more quickly