thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Calculated Column

A DAX column computed row by row at data refresh and stored in the model, usable in slicers, filters and axes.

Definition

Calculated columns use row context and consume memory. Where possible, create such columns in Power Query or the source instead. Use them when you need to slice by the result.

Example

Age Band = IF(Customer[Age] < 30, "Under 30", "30+")

Exam tip

Need to put the result on an axis or slicer = calculated column (or Power Query); need dynamic aggregation = measure.

Related terms