Module quiz: Using DAX in Power BI :Data Modeling in Power BI (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

tion 1

Which syntax can you use to compute sales data for the previous month?

❌

❌

✅

Explanation:
Time-intelligence functions like PREVIOUSMONTH must be used inside CALCULATE, and the aggregation (SUM) must be inside CALCULATE.

Question 2

Adventure Works must compute sales of mountain bikes in the UK for 2020. Which functions change context and compute accurate values?
(Select all that apply)

✅ CALCULATE
✅ FILTER
❌ FILTERS

Explanation:

• CALCULATE changes the filter context

• FILTER applies row-level conditions

• FILTERS only returns existing filters and does not change context

Question 3

How can you count the number of orders each customer places?

❌ COUNTROWS with RELATED
✅ COUNTROWS with FILTER
❌ COUNTX with RELATED

Explanation:
COUNTROWS + FILTER is the correct approach to count related rows in another table.

Question 4

What is the purpose of the CROSSFILTER function in DAX?

❌ To remove filters from a table
❌ To establish temporary relationships
✅ To filter data between two tables based on relationship direction

Explanation:
CROSSFILTER modifies how filters flow between related tables during evaluation.

Question 5

How can you use an inactive relationship to compute a single measure?

✅ By using the USERELATIONSHIP function
❌ By changing the active relationship in Modeling tab
❌ By deleting the active relationship

Explanation:
USERELATIONSHIP temporarily activates an inactive relationship within a measure.

Question 6

Which is an advantage of using measures over calculated columns?

❌ Measures can be used for transformation
✅ Measures are more efficient and require less memory
❌ Measures can be used in calculated columns

Explanation:
Measures are calculated at query time and do not store values, saving memory.

Question 7

Which DAX functions can calculate the running total of revenue for each store?
(Select all that apply)

❌ RANKX
✅ TOTALYTD
✅ SUMX

Explanation:

• TOTALYTD is a built-in running total function

• SUMX can be used with FILTER logic to calculate running totals

Question 8

What is the purpose of time intelligence in Power BI?

❌ To manipulate date values only
✅ To perform calculations involving periods and trends
❌ To visualize dates using custom visuals

Explanation:
Time intelligence enables calculations such as YTD, MTD, YoY, and trend analysis.

Question 9

After creating a Date table using DAX, what must you do to ensure time intelligence works correctly?

❌ Add time intelligence measures to the Date table
❌ Add a date hierarchy
✅ Mark the Date table as a Date table

Explanation:
Power BI requires the Date table to be marked as a Date table for time intelligence functions.

Question 10

When using CALCULATE, which contexts influence the evaluation?
(Select all that apply)

❌ Row context
❌ Column context
✅ Filter context

Explanation:
CALCULATE modifies and evaluates expressions in the filter context.

🧾 Summary Table