DashCoreHub
Mission M19 · DAX · 20 min
Year-over-year growth: 2025 vs 2024
Request from your manager
The CEO is preparing the annual letter to investors: "Did we grow in 2025 compared with 2024? Give me one percentage."
Data
Download the practice file(s):
Steps
- Use the 'Date' table from the previous mission (marked as date table and related to orders).
- Create Sales PY with CALCULATE and SAMEPERIODLASTYEAR.
- Create Sales YoY % = DIVIDE([Total Net Sales] - [Sales PY], [Sales PY]).
- Put 'Date'[Year] in a table with [Total Net Sales], [Sales PY] and [Sales YoY %].
- Read the 2025 row (2024 shows blank because there is no 2023 data).
Check your answer
What is the YoY net sales growth % of 2025 vs 2024?
Show solution
2025 net sales were $127,574.62 and 2024 were $120,068.98, so growth = (127,574.62 − 120,068.98) / 120,068.98 = 6.25%.
Sales PY =
CALCULATE ( [Total Net Sales], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
Sales YoY % =
DIVIDE ( [Total Net Sales] - [Sales PY], [Sales PY] )Answer: 6.25 %