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.