https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-the-max-of-rows-from-5-different-columns/m-p/3469788#M132470 <DIV class=""><DIV class=""><DIV class="">How to find the max of rows from 5 different columns</DIV></DIV></DIV><DIV class=""><SPAN class=""><SPAN class="">49 seconds ago</SPAN></SPAN></DIV><DIV class=""><DIV class=""><P>I have a table called App with three calculated columns Level1, Level2, Level3, Level4, Level5.&nbsp;</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Level1</TD><TD>Level2</TD><TD>Level3</TD><TD>Level4</TD><TD>Level5</TD></TR><TR><TD>0</TD><TD>2</TD><TD>3</TD><TD>0</TD><TD>5</TD></TR><TR><TD>1</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1</TD><TD>0</TD><TD>0</TD><TD>4</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>3</TD><TD>0</TD><TD>5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need to write a calculated column formula to find the max of each row. For example: For row1: Max of 0,2,3,0,5 is 5 and likewise for all rows.</P></DIV></DIV> Tue, 10 Oct 2023 21:03:15 GMT Khushboo9966 2023-10-10T21:03:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-the-max-of-rows-from-5-different-columns/m-p/3469788#M132470 <DIV class=""><DIV class=""><DIV class="">How to find the max of rows from 5 different columns</DIV></DIV></DIV><DIV class=""><SPAN class=""><SPAN class="">49 seconds ago</SPAN></SPAN></DIV><DIV class=""><DIV class=""><P>I have a table called App with three calculated columns Level1, Level2, Level3, Level4, Level5.&nbsp;</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Level1</TD><TD>Level2</TD><TD>Level3</TD><TD>Level4</TD><TD>Level5</TD></TR><TR><TD>0</TD><TD>2</TD><TD>3</TD><TD>0</TD><TD>5</TD></TR><TR><TD>1</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1</TD><TD>0</TD><TD>0</TD><TD>4</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>3</TD><TD>0</TD><TD>5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need to write a calculated column formula to find the max of each row. For example: For row1: Max of 0,2,3,0,5 is 5 and likewise for all rows.</P></DIV></DIV> Tue, 10 Oct 2023 21:03:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-the-max-of-rows-from-5-different-columns/m-p/3469788#M132470 Khushboo9966 2023-10-10T21:03:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-the-max-of-rows-from-5-different-columns/m-p/3469931#M132483 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="626041" data-lia-user-login="Khushboo9966" class="lia-mention lia-mention-user">Khushboo9966</a>&nbsp;</P><P>MaxRow = MAXX(App, MAX(App[Level1], App[Level2], App[Level3], App[Level4], App[Level5]))</P><P>&nbsp;</P><P>Let me know if this works</P> Tue, 10 Oct 2023 22:42:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-the-max-of-rows-from-5-different-columns/m-p/3469931#M132483 DallasBaba 2023-10-10T22:42:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-the-max-of-rows-from-5-different-columns/m-p/3471367#M132546 <P>Thank you. The above formula won't work because Max allows only 2 arguements.&nbsp;</P><P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="507" data-lia-user-login="parry2k" class="lia-mention lia-mention-user">parry2k</a>&nbsp;provided the below solution and it worked.&nbsp;</P><PRE>Column = MAXX ( UNION ( { [Level1] }, { [Level2] }, { [Level3] }, { [Level4] }, { [Level5] } ), [Value] )</PRE><P>&nbsp;</P><P>&nbsp;</P> Wed, 11 Oct 2023 14:05:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-the-max-of-rows-from-5-different-columns/m-p/3471367#M132546 Khushboo9966 2023-10-11T14:05:25Z