cancel
Showing results for
Did you mean:
scottkad Frequent Visitor

## DAX Calculate the Max for a Group

Hello!  I have a problem and have a feeling a simple DAX formula can solve it.

I would like the 'Desired Output' column to be the Max of the 'Check' column, evaluated for each Name. Any help is much appreciated, thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
scottkad Frequent Visitor

## Re: DAX Calculate the Max for a Group

Thanks for the post ashishrj,

After many more google searches I was able to find this, Stack Overflow Calc Max

`Desired Output=CALCULATE(MAX([Check]),FILTER(Table1,[Name]=EARLIER([Name])))`

3 REPLIES 3
ashishrj Senior Member

## Re: DAX Calculate the Max for a Group

@scottkad You can use MAX() DAX expression. In your case Desired Output = MAX (TableName[Check]). Let me know if this is what you are looking for !

scottkad Frequent Visitor

## Re: DAX Calculate the Max for a Group

Thanks for the post ashishrj,

After many more google searches I was able to find this, Stack Overflow Calc Max

`Desired Output=CALCULATE(MAX([Check]),FILTER(Table1,[Name]=EARLIER([Name])))`

Highlighted
Shmidtk Frequent Visitor

## Re: DAX Calculate the Max for a Group

But what you going to do if you have unsorted list? You can't really on ordering in general. Is there is way to do this without order dependence?