Filter Context – The Whiteboard #01
Introduce the filter context in the first episode of The Whiteboard! Watch now
Row Context – The Whiteboard #02
Learn what the row context is in DAX with a more graphical explanation! Watch now
Context Transition – The Whiteboard #03
A context transition in DAX transforms a row context into an equivalent filter context: a picture is worth a thousand words! Watch now
Expanded Table – The Whiteboard #04
What is an expanded table in DAX? Seeing it is better than a simple description! Watch now
Variables – The Whiteboard #05
A variable is a constant in DAX. Is it more clear if we draw it? Watch now
Formula Engine – The Whiteboard #06
Let’s draw what the formula engine does when executing a DAX query. Watch now
Storage Engine (VertiPaq) – The Whiteboard #07
How does the VertiPaq storage engine communicate with the formula engine when executing a DAX query? Watch now
One-to-Many Relationships – The Whiteboard #08
The basic relationships are one-to-many in most databases, DAX is no exception! Watch now
Invalid Relationships – The Whiteboard #09
An invalid relationship in DAX is a regular relationship that has bad data… Watch now
Regular and Limited Relationships – The Whiteboard #10
Do you know the difference between regular and limited relationships in DAX? Watch now