A sales manager who is not familiar with DAX wants to create a measure that shows the running total of sales over time. The manager needs to complete this task quickly without writing DAX code manually. Which feature should the manager use?

A new measure created with the SUM function

Quick Measures with the Running total calculation

A calculated column using the EARLIER function

The built-in Total Sales measure from the Sales table

A sales manager wants to create a measure that shows the running total of sales over time. The manager is not familiar with DAX. Which feature should they use to create this measure quickly?

Write a DAX measure using CALCULATE and FILTER.

Create a calculated column using EARLIER to compute the running total.

Use the 'New Measure' dialog and select 'Running total' from the template.

Quick Measures and select 'Running total'.

A sales analyst wants to create a measure that shows the year-over-year growth percentage for total sales. The analyst is not comfortable writing DAX manually. Which approach should the analyst use?

Use the 'New Measure' button and select 'Year over year growth' from the template.

Write a DAX measure using CALCULATE and SAMEPERIODLASTYEAR manually.

Create a calculated column that subtracts last year's sales from this year's sales.

Use the Quick Measures feature and select 'Year over year change'.

A data model has a Sales table with columns: OrderID, CustomerID, OrderDate, and Amount. The company wants to create a separate table that shows the total sales per customer for the year 2023. Which DAX expression should you use to create a calculated table?

CALCULATETABLE(SUMMARIZE(Sales, Sales[CustomerID], "TotalSales", SUM(Sales[Amount])), Sales[OrderDate] >= DATE(2023,1,1), Sales[OrderDate] <= DATE(2023,12,31))

SUMMARIZE(Sales, Sales[CustomerID], "TotalSales", SUM(Sales[Amount]))

SUMMARIZECOLUMNS(Sales[CustomerID], "TotalSales", SUM(Sales[Amount]))

FILTER(SUMMARIZE(Sales, Sales[CustomerID], "TotalSales", SUM(Sales[Amount])), Sales[OrderDate] >= DATE(2023,1,1))

Microsoft Certified:Power BI Data Analyst Associate

Domain 2Objective 2

Create Model Calculations by Using DAX PL-300 Practice Questions (Page 1)

Part of the Model the data domain, which accounts for 25–30% of the PL-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 3–7 from this objective — we provide 25 practice questions to prepare you well beyond it. (estimate)

25questions here

5free pages

8concepts

25–30%of the exam

Questions 1–5

1application · easy
A sales manager who is not familiar with DAX wants to create a measure that shows the running total of sales over time. The manager needs to complete this task quickly without writing DAX code manually. Which feature should the manager use?
Select an answer first
2application · easy
A sales manager wants to create a measure that shows the running total of sales over time. The manager is not familiar with DAX. Which feature should they use to create this measure quickly?
Select an answer first
3application · easy
A sales analyst wants to create a measure that shows the year-over-year growth percentage for total sales. The analyst is not comfortable writing DAX manually. Which approach should the analyst use?
Select an answer first
4foundation · easy
Which DAX function counts the number of distinct values in a column?
Select an answer first
5application · medium
A data model has a Sales table with columns: OrderID, CustomerID, OrderDate, and Amount. The company wants to create a separate table that shows the total sales per customer for the year 2023. Which DAX expression should you use to create a calculated table?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-300” is a trademark of its owner, used for identification only.