Sales by year
It seems we have sales information for all years together, but we want to focus on comparing years separately. To be able to calculate the current stock, you will first have to calculate the amount of items sold in 2021 and 2022 for each item.
We recommend you to keep working in your own workbook but if you lost progress you can open 1_4_revenue_and_profit_solution.pbix
from the Exercises folder on the Desktop
This exercise is part of the course
Case Study: Inventory Analysis in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
