Forum Discussion

scottkad's avatar
scottkad
Icon for Advocate II rankAdvocate II
10 years ago
Solved

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.    ...
  • scottkad's avatar
    scottkad
    10 years ago

    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])))

     

scottkad's avatar
scottkad
Icon for Advocate II rankAdvocate II
10 years ago

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])))

 

Shmidtk's avatar
Shmidtk
New Member
8 years ago

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?