Power BI Masterclass - Calculate Our Base Measures

The video tutorial guides viewers through setting up additional measures in a data analysis context. It covers calculating total cost and total profit by using measures and iterating over tables. The tutorial also introduces time intelligence functions to calculate sales, cost, and profit for the previous year. Finally, it demonstrates how to calculate profit growth by comparing current and previous year profits.

What function is used to iterate over the orders table to calculate the total cost?

• MAX

• COUNT

• AVERAGE

• SUMX

How is the total profit calculated in the video?

• By dividing total sales by total cost

• By adding total sales and total cost

• By subtracting total cost from total sales

• By multiplying total sales by total cost

Which function is used to calculate last year's total sales?

• SAMEPERIODLASTYEAR

• YEARTODATE

• LASTYEAR

• PREVIOUSYEAR

What is the main focus of the final section of the video?

• Calculating profit growth

• Calculating total cost

• Calculating total sales

• Calculating last year's sales

How is profit growth calculated in the video?

• As a ratio of current to last year's profit

• As a sum of current and last year's profit

• As a difference between current and last year's profit

• As a percentage of total sales