PL-300 · 2.2.7 · Model the data
Writing calculated tables, columns
Create calculated tables or columns
Create for row values and for stored table expressions.
Calculated column
A evaluates in and stores one result for every row.
Full Name = Staff[FirstName] & " " & Staff[LastName]Use it when the new value must become a reusable field for filtering, sorting, grouping, , or display.
Calculated table
Regional Staff =
UNION('East Staff', 'West Staff')A is evaluated during refresh and returns an entire stored table. It can then participate in relationships and model structure.
Do not confuse stored and dynamic results
Calculated columns and tables recalculate on refresh. recalculate in report . A calculated column therefore cannot react differently when a reader changes a .
Exam clue: row-by-row stored field = calculated column; stored table expression = calculated table; interactive result = measure.
Key points
- : evaluated per row
- : DAX returns a new table
- Refresh: recalculates stored results
- : react to visual filters instead
Click an underlined term for a one-line explanation, or see them all in the glossary .
Exam trap
Do not use a for a result that must change with visual .
Sources · 2 Microsoft Learn pages Show ▾
Checked on October 4, 2026. Report a problem
Go deeper on Microsoft Learn
Checked against Microsoft Learn on October 4, 2026. Report a problem with this card