cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
scottkad Frequent Visitor
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. 

 

desired output.JPG

Any help is much appreciated, thanks. 

1 ACCEPTED SOLUTION

Accepted Solutions
scottkad Frequent Visitor
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
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
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
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?