Table of Contents
The best method for finding the maximum value among multiple columns in Power BI is by using the MAX function. This function allows the user to specify the columns they want to evaluate and returns the maximum value from those columns. Additionally, the user can use the MAXX function to apply further filters or calculations to their data before finding the maximum value. This method is efficient, accurate, and easy to implement, making it the recommended approach for finding the maximum value in Power BI.
Find Max of Multiple Columns in Power BI
The easiest way to find the max value across multiple columns in Power BI is to use the Maximum function in the Add column tab of the Power Query Editor.
The following example shows how to use this function in practice.
Example: How to Find Max of Multiple Columns in Power BI
Suppose we have the following table in Power BI named my_data that contains information about points scored by various basketball players during three different games:
Suppose we would like to create a new column that shows the max value of points scored by each player across all three games.
To do so, click the Transform data icon on the Home tab:
Next, click the Add column tab along the top ribbon.
Then hold Ctrl and select the column headers for Game 1, Game 2 and Game 3.
Then click the Statistics icon, then click Maximum from the dropdown menu:
A new column named Maximum will be created that shows the max points scored by each player across all three games:
From the output we can see:
- The max points scored by the Mavs player across the three games was 14.
- The max points scored by the Spurs player across the three games was 17.
- The max points scored by the Rockets player across the three games was 22.
And so on.
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: