Which of the following is true about calculated columns vs measures in DAX?

Calculated columns are stored in the model and consume memory, whereas measures are computed at query time

Calculated columns are evaluated at query time, while measures are pre-computed

Measures are stored in memory like calculated columns

Calculated columns are stored in the model and consume memory, whereas measures are computed at query time

Both are evaluated at data load time

What is the purpose of the CALCULATE function in DAX?

To change the filter context of a calculation

To return only the first row of a table

To change the filter context of a calculation

What is a row context in DAX?

It refers to the context of a single record while evaluating a formula

It applies to filters in reports

It refers to the context of a single record while evaluating a formula

It helps in creating calculated tables

PowerBI - Sample Questions

8 questions3 Easy3 Medium2 Hard

Preview limited to 8 questions. To protect the integrity of our question library and prevent answer leaks, only a curated sample is shown here. Assessments draw from a much larger, continuously updated bank of questions.

Easydaxcalculated columns1 point

Which function is used to create calculated columns in DAX?

PowerBI - Sample Questions

8 questions3 Easy3 Medium2 Hard

Easydaxcalculated columns1 point

Which function is used to create calculated columns in DAX?

Quick Links

Our Solutions

Knowledge Hub

PowerBI - Sample Questions

PowerBI - Sample Questions