Sales by category and year
In previous exercises, you've calculated revenue by using a SUM()
function to total the LinePrice
column. Now you'll need to calculate the total sales and filter by category Bikes and order year 2018.
In this exercise, we will be utilizing the CALCULATE()
function. You can read up on this function in Microsoft Documentation.
If you lost progress, close any open reports and load 2_3_calculate.pbix
from the Exercises folder.
This exercise is part of the course
Introduction to DAX in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
