Common DAX functions (time intelligence, FILTER, CALCULATE, and so on)
There are over 250 DAX functions. We will not be covering all these functions in this book, but we will use and apply the most common functions to our sales dashboard.
Earlier, we calculated our first DAX formula using SUM
. SUM
falls under the category of DAX functions called aggregation functions. They are responsible for computing scalar values, such as sums, averages, minimums, maximums, and counts, across all rows within a column or table in our data model.
Here are some other categories of DAX functions and what they can be used to calculate:
- Filter functions: These functions assist in fetching specific data types, searching for values in related tables, and applying filters based on associated values. Lookup functions operate by utilizing tables and their relationships. Filtering functions provide the ability to modify the data context, enabling the creation of dynamic calculations. This includes...