Topic: DAX
-
Calculation groups are the most important feature introduced in DAX after variables in 2015. By using calculation groups, you can apply transformations to existing measures without having to create new measures in the model. For example, you can define the… Watch now
-
An invalid relationship in DAX is a regular relationship that has bad data… Watch now
-
Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this video, we introduce this optimization with some examples. Watch now
-
A common question is why Power BI totals are inaccurate because they do not display the sum of individual rows. In this video, we explain the reasons why those totals are correct. Watch now
-
The basic relationships are one-to-many in most databases, DAX is no exception! Watch now
-
How to enable the cross-highlight in Power BI charts using different dates for the same event, such as Order Date and Delivery Date. Watch now
-
How does the VertiPaq storage engine communicate with the formula engine when executing a DAX query? Watch now
-
RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies. Watch now
-
Let’s draw what the formula engine does when executing a DAX query. Watch now
-
Introduction to ALLSELECTED, which is an extremely complex function to use in DAX. Watch now