DSC 570 – Week 4 Pre-assessment | Questions and Answers | 2026 Update | 100% Correct.
Which of the following options performs calculations by using
specific values, or arguments, in a particular order or structure?
Calculated measure
Date table
DAX function
Formula bar
What is helpful for showing data at a different level of detail for
analysis?
Formula bar
DAX function
Date table
Calculated measure
Answer Calculated measure is correct.
A calculated measure is helpful for showing data at a different level of detail
for analysis. It is a calculated field based on an existing measure in the data
with a formula and aggregation applied to refine the data.
Which of the following functions will modify the filter context prior
to the evaluation?
AVERAGE
REPLACE
ISBLANK
CALCULATE
Answer CALCULATE is correct.
The CALCULATE function modifies the filter context prior to the evaluation.
It is particularly useful when users are calculating time intelligence
measures such as year-to-date sales or year-over-year growth.
, Which of the following is displayed when a user selects the New
measure or New column command?
Date table
Formula bar
DAX function
Calculated measure
Answer Formula bar is correct.
When a user selects the New measure or New column command, a formula
bar is displayed on the top of the canvas. A formula bar is an interface
element in Power BI and the Query Editor used to construct custom
expressions and queries.
Which of the following is a function that enables users to manipulate
data using durations, including days, months, quarters, and years?
Time intelligence
Logical
Calculated measure
Conditional column
Answer Time intelligence is correct.
DAX time-intelligence functions enable users to manipulate data using
durations, including days, months, quarters, and years and then build and
compare calculations over those periods. To use these functions, the data
model must include at least one date table.
Which of the following ribbons can be used to create calculated
columns?
View
Insert
Modeling
Home
Answer Modeling is correct.
Which of the following options performs calculations by using
specific values, or arguments, in a particular order or structure?
Calculated measure
Date table
DAX function
Formula bar
What is helpful for showing data at a different level of detail for
analysis?
Formula bar
DAX function
Date table
Calculated measure
Answer Calculated measure is correct.
A calculated measure is helpful for showing data at a different level of detail
for analysis. It is a calculated field based on an existing measure in the data
with a formula and aggregation applied to refine the data.
Which of the following functions will modify the filter context prior
to the evaluation?
AVERAGE
REPLACE
ISBLANK
CALCULATE
Answer CALCULATE is correct.
The CALCULATE function modifies the filter context prior to the evaluation.
It is particularly useful when users are calculating time intelligence
measures such as year-to-date sales or year-over-year growth.
, Which of the following is displayed when a user selects the New
measure or New column command?
Date table
Formula bar
DAX function
Calculated measure
Answer Formula bar is correct.
When a user selects the New measure or New column command, a formula
bar is displayed on the top of the canvas. A formula bar is an interface
element in Power BI and the Query Editor used to construct custom
expressions and queries.
Which of the following is a function that enables users to manipulate
data using durations, including days, months, quarters, and years?
Time intelligence
Logical
Calculated measure
Conditional column
Answer Time intelligence is correct.
DAX time-intelligence functions enable users to manipulate data using
durations, including days, months, quarters, and years and then build and
compare calculations over those periods. To use these functions, the data
model must include at least one date table.
Which of the following ribbons can be used to create calculated
columns?
View
Insert
Modeling
Home
Answer Modeling is correct.
