BenchMark Quizzes by MDFT Pro

Select Components For Year-To-Date Sales Quick Measure In Power BI

MDFT Pro, a leading training organization, maintains two tables in Power BI: ‘Calendar’ and ‘Transactions’. The academy’s management wants to monitor how much sales revenue has been generated so far this year to track progress toward their annual targets.

You have been asked to create a quick measure in Power BI that calculates year-to-date (YTD) sales. Which components must you select when setting up this YTD sales quick measure?

Choose all correct answers from the options below.

Explanations for each answer:

Set Calculation to: Year-to-date total is correct. The 'Year-to-date total' calculation is designed to accumulate values from the start of the year up to the current date, which is essential for tracking progress toward annual sales goals.
Set Base value to: Sum of Sales is correct. Selecting 'Sum of Sales' as the base value ensures that the quick measure aggregates all sales transactions, providing the total sales amount for the year-to-date calculation.
Set Date to: Date column from Calendar table is correct. The Date column from the Calendar table is required for time-intelligence calculations, allowing Power BI to correctly compute year-to-date values based on dates.
Set Calculation to: Year-over-year change is incorrect. The 'Year-over-year change' calculation is used to compare performance between years, not to calculate cumulative totals for the current year.

Learn more about quick measures in Power BI:

Power BI Quick Measures

Exam Preparation Quiz

Select Components For Year-To-Date Sales Quick Measure In Power BI