Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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)
Solved! Go to 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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
49 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |