What is the primary purpose of a calculated column in Power BI?

To filter data during data import

To create a new table from a DAX expression

To define a measure that can be used in visuals

To add a new column to an existing table based on a DAX expression

A financial services company has a data model with 15 measures, including Total Revenue, Total Expenses, and Net Income. The company wants users to be able to switch between viewing these measures as raw values, as a percentage of total, or as a year-over-year change, without creating 45 separate measures. The solution must be maintainable and require minimal changes to existing visuals. Which approach should you use?

Create three separate measures for each base measure, resulting in 45 measures total

Create a calculated table with all combinations of measures and calculation types

Create a calculation group with calculation items for Raw Value, % of Total, and YoY Change, then apply it to the measures

Use a single measure with a SWITCH statement that checks a parameter table

Microsoft Certified:Power BI Data Analyst Associate

Domain 2Objective 2

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

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 16–20

16foundation · easy
Which DAX function returns the last non-blank value in a column, ordered by a specified column?
Select an answer first
17application · easy
A business analyst wants to create a measure that shows the year-over-year percentage change in sales. The analyst is comfortable with the Quick Measures feature but has limited DAX experience. Which Quick Measures calculation should the analyst select?
Select an answer first
18foundation · easy
What is the primary purpose of a calculated column in Power BI?
Select an answer first
19expert · hard
A financial services company has a data model with 15 measures, including Total Revenue, Total Expenses, and Net Income. The company wants users to be able to switch between viewing these measures as raw values, as a percentage of total, or as a year-over-year change, without creating 45 separate measures. The solution must be maintainable and require minimal changes to existing visuals. Which approach should you use?
Select an answer first
20foundation · easy
Which DAX function is used to modify the filter context of a calculation?
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.

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

Questions 16–20

Which DAX function returns the last non-blank value in a column, ordered by a specified column?

A business analyst wants to create a measure that shows the year-over-year percentage change in sales. The analyst is comfortable with the Quick Measures feature but has limited DAX experience. Which Quick Measures calculation should the analyst select?

What is the primary purpose of a calculated column in Power BI?

Which DAX function is used to modify the filter context of a calculation?

Keep studying — Model the data