Forum Discussion

gmasta1129's avatar
gmasta1129
Resolver I
1 year ago
Solved

Formula to pull max value based off another column

Hello,   I would like to pull the maximum number in the "Total" column based off the customer account number.  My data has thousands of rows.  I need the maximum value to pull into the new column...
Need Help
  • muhammad_786_1's avatar
    muhammad_786_1
    1 year ago

    Hi gmasta1129 

     

    You can try this DAX to get your desire output by create new calculated column.

     

    Best Regards,
    Muhammad Yousaf

     

    If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

     

    LinkedIn

     

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

gmasta1129 

Create a calculated column:

New Column (Maximum Value) =
VAR MaxValue = CALCULATE(
MAX('Table'[Total]),
ALLEXCEPT('Table', 'Table'[Customer Account Number])
)
RETURN IF('Table'[Total] = MaxValue, MaxValue, 0)

This approach will create a column in which only the row with the maximum value for each Customer Account Number shows the max value, while other rows display 0, just like in your Excel formula.

 

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn