All lessons

Power BI and DAX glossary

60 words from the course, in plain English. "Also called" lists other names and related functions you will meet. Each term links to the lesson that explains it.

ABCDFGIKMPQRSTUVW

A

ALL
Also called: REMOVEFILTERS. Removes filters from a table or columns, so a measure sees every row. The usual denominator of a percent of total. Lesson 5.3
ALLEXCEPT
Removes every filter on a table except those on the columns you list. Lesson 5.3
ALLSELECTED
Removes the filters from the visual's own rows and columns but keeps slicers and page filters: "percent of what I selected". Lesson 5.3
App
Also called: Power BI app. A package of reports and dashboards from a workspace, published to a wide audience who only read. Lesson 8.3
Append
Also called: union. Stacking tables with the same columns on top of each other in Power Query. Lesson 2.3
Applied steps
The list of transformations in Power Query, replayed in order on every refresh. Lesson 2.1

B

Bookmark
A saved state of a report page (filters, visible visuals, drill level) that a button can bring back. Lesson 7.4

C

CALCULATE
Evaluates an expression after changing the filter context. Each filter argument replaces the filter on the same column; it also performs context transition. Lesson 5.2
Calculated column
A column worked out once per row at refresh with DAX and stored in the model. Usable in slicers and on rows; costs memory. Lesson 3.4
CALENDAR
Also called: CALENDARAUTO. DAX functions that make a table of every date between two dates, the start of a date table. Lesson 3.3
Cardinality
How rows of two related tables match: one-to-many, one-to-one or many-to-many. Also: how many distinct values a column has. Lesson 3.2
Context transition
CALCULATE (or a measure reference, which has a hidden CALCULATE) turning the current row of a row context into a filter context. Lesson 5.5
Cross-filter direction
Also called: filter direction. Which way filters travel along a relationship: single (from the one side to the many side) or both. Lesson 3.2

D

Dashboard
In the Power BI service, a single page of tiles pinned from one or more reports. Lesson 8.3
Date table
Also called: calendar table. A table with one row per day, no gaps, covering whole years, marked as a date table. Time intelligence needs one. Lesson 3.3
DATESINPERIOD
Returns the dates in a window ending (or starting) on a given date, such as the last 28 days. The base of rolling totals. Lesson 6.3
DATESYTD
Also called: TOTALYTD. Returns the dates from the start of the year to the last date in the filter context. Used for year to date. Lesson 6.1
DAX
Also called: Data Analysis Expressions. The formula language for measures, calculated columns, calculated tables and security rules in Power BI. Lesson 4.1
DAX query
Also called: EVALUATE. A statement that returns a table, starting with EVALUATE, run in DAX query view or DAX Studio to test and inspect. Lesson 5.7
Dimension table
Also called: lookup table. A table that describes things (products, stores, dates), with one row per thing. Filters the fact table. Lesson 3.1
DIVIDE
Division that returns blank (or a value you choose) instead of an error when the denominator is zero or blank. Lesson 4.2
Drill down
Also called: drill through. Drill down moves to the next level of a hierarchy in the same visual; drill through jumps to a detail page filtered to what you clicked. Lesson 7.3

F

Fact table
A table of events or transactions (sales lines), with keys to the dimensions and numbers to add up. Lesson 3.1
Field parameter
A slicer that changes which column or measure a visual shows, so one chart can switch between Sales, Margin and Quantity. Lesson 8.5
FILTER
An iterator that returns the rows of a table where a condition is true. Needed inside CALCULATE for conditions on measures or several columns. Lesson 5.4
Filter context
The set of filters on a calculation, from the visual's rows and columns, slicers, filter panes and CALCULATE. Decides which rows a measure sees. Lesson 5.1

G

Gateway
Also called: on-premises data gateway. Software on a machine inside a private network that lets the Power BI service refresh data stored there. Lesson 8.4
Grain
What one row of a table stands for, such as one sales line per order, or one target per store per month. Lesson 3.5
Group By
A Power Query step that summarises rows into one row per group, with totals or counts. Lesson 2.4

I

Iterator
Also called: X function. A function such as SUMX, AVERAGEX or RANKX that walks a table row by row, evaluating an expression in a row context. Lesson 4.3

K

KEEPFILTERS
Wraps a CALCULATE filter so it is added to the existing filter on that column instead of replacing it. Lesson 5.2

M

M
Also called: Power Query formula language. The language Power Query writes behind each applied step; you can read and edit it in the Advanced Editor. Lesson 2.5
Measure
A DAX formula worked out at query time for each cell of a visual, in that cell's filter context. Stores nothing. Lesson 4.1
Merge
Also called: join. Joining two tables side by side on matching key columns in Power Query, like a SQL join. Lesson 2.3
Model view
The Power BI Desktop view that shows tables as boxes and relationships as lines. Lesson 1.3

P

Performance Analyzer
A Desktop pane that times each visual, split into DAX query, visual display and other time. Lesson 8.1
Power Query
The data preparation tool in Power BI and Excel: connect, clean, reshape and combine data before it is loaded. Lesson 2.1

Q

Query folding
Also called: folding. Power Query turning applied steps into a single query the source runs itself, so less data is downloaded. Lesson 2.5

R

RANKX
Ranks each row of a table by an expression. Usually over ALL of a column, so each item is compared with every other. Lesson 5.6
Relationship
A link between a column in one table and a column in another, along which filters flow. Lesson 3.2
Report
Pages of visuals built on a semantic model, in Desktop or the service. Lesson 1.4
Row context
"The current row" while a calculated column or iterator runs. It does not filter anything by itself. Lesson 5.1
Row-level security
Also called: RLS. Roles with DAX filters that limit which rows each user sees in the published report. Lesson 8.2

S

SAMEPERIODLASTYEAR
Also called: DATEADD. Shifts the dates in the filter context back one year, for last year and growth measures. Lesson 6.2
Scheduled refresh
Automatic reloading of a semantic model in the service at set times (up to 8 a day on Pro). Lesson 8.4
Semantic model
Also called: dataset. The data, relationships and measures behind reports, published to the service as its own item. Lesson 8.3
Slicer
A visual that filters the other visuals on a page when you pick values. Lesson 7.2
Star schema
A model with a fact table in the middle and dimension tables around it, each joined one-to-many. Lesson 3.1
SUMX
Adds up an expression evaluated row by row over a table, such as Quantity × UnitPrice. Lesson 4.3
SWITCH
Returns the result for the first matching value or true condition; a tidy replacement for nested IF. Lesson 4.5

T

Time intelligence
DAX functions that shift or extend dates (year to date, last year, rolling windows). They need a date table. Lesson 6.1
Tooltip page
Also called: report page tooltip. A small report page that appears when hovering over a data point, filtered to it. Lesson 7.3
TOPN
Returns the top N rows of a table by an expression. Lesson 5.6
TREATAS
Applies the values of one column as a filter on another column with no relationship, such as months from Date onto Targets. Lesson 6.4

U

Unpivot
Turning many columns (one per month) into two columns (attribute and value), so the data is long and easy to model. Lesson 2.4
USERELATIONSHIP
Also called: inactive relationship. Turns on an inactive (dashed) relationship inside one CALCULATE. Lesson 3.2

V

VAR
Also called: variable. Names a step in a DAX formula, worked out once where it is defined, and returned with RETURN. Lesson 4.5
VertiPaq
Also called: Import mode storage engine. The in-memory, column-by-column compressed store that holds imported data. Lesson 8.1

W

Workspace
A shared area in the Power BI service where a team keeps reports, models and dashboards. Lesson 8.3

See also the DAX cheat sheet.