Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Sales for current year less 2

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)

 

Need Help
  • goncalogeraldes's avatar
    goncalogeraldes
    5 years ago

    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

     

1 Reply

  • goncalogeraldes's avatar
    goncalogeraldes
    Icon for Super User rankSuper User
    5 years ago

    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