Mode is a common mathematical concept defined as the most frequently occurring value in a series. Excel has a built-in function called MODE for calculating the mode of a series of values. However, DAX has no such equivalent function. This recipe demonstrates how to calculate the mode of a series of values using DAX.
To prepare for this recipe, perform the following steps:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R08_Table1 with the following data: