{"id":1978,"date":"2023-03-03T10:13:33","date_gmt":"2023-03-03T10:13:33","guid":{"rendered":"https:\/\/monocroft.com\/?p=1978"},"modified":"2023-03-03T10:13:35","modified_gmt":"2023-03-03T10:13:35","slug":"how-to-find-the-max-value-of-multiple-columns-for-every-row","status":"publish","type":"post","link":"https:\/\/monocroft.com\/how-to-find-the-max-value-of-multiple-columns-for-every-row\/","title":{"rendered":"How to Find the Max Value of Multiple Columns for Every Row"},"content":{"rendered":"\n

In Power BI, to find the max value of multiple columns for every row in DAX, you can use the MAX <\/strong>function as well as the SUMMARIZE <\/strong>function.<\/p>\n\n\n\n

The purpose of the SUMMARIZE <\/strong>function is to group a table by one or more columns and create a new table that contains the grouped data. <\/p>\n\n\n\n

In this article, I will explain how to group a table by one or more columns, find the max value of the columns, and create a new table with the grouped and aggregated data.<\/p>\n\n\n\n

Let’s get started.<\/p>\n\n\n\n

Getting started: How to Find the Max Value of Multiple Columns for Every Row<\/h2>\n\n\n\n

To start with, you will use the SUMMARIZE <\/strong>function to group your table by one or more columns. Then create a new table that contains the grouped data. <\/p>\n\n\n\n

The SUMMARIZE Function<\/h2>\n\n\n\n

The SUMMARIZE <\/code><\/strong>function syntax for this process is:<\/p>\n\n\n\n

SUMMARIZE([table], [group_by_column1], [group_by_column2], ...], [aggregate_column1], [aggregate_column2], ...])<\/code><\/strong><\/pre>\n\n\n\n

Where:<\/p>\n\n\n\n