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. 

 



Any help is much appreciated, thanks. 

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

     

3 Replies

  • ashishrj's avatar
    ashishrj
    Icon for Power Participant rankPower Participant
    10 years ago

    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'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?