DAX Sales for current year less 2

[Anonymous]

Hi Experts

I want to amend the current measure to give me the sale for 2019 (less 2 years) the current measure return the sameperiodlastyear. I want the new measure to give same period less 2 years.

NetSales YoY% =
VAR CY = [Overall NS]

VAR PY = Calculate([Overall NS],SAMEPERIODLASTYEAR(Calendar[Date], ALL(Calendar))

Return
Divde (CY - PY, PY,0)

[goncalogeraldes · Accepted solution]

Hello there @Anonymous ! Maybe this can work:

NetSales YoY% =
VAR CY = [Overall NS]

VAR PY = Calculate([Overall NS],PARALLELPERIOD(Calendar[Date], -2, YEAR))

Return
Divde (CY - PY, PY,0)

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes