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

     

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?