Forum Discussion

bheinrich's avatar
bheinrich
Frequent Visitor
8 years ago
Solved

Generating the highest value within a particular group

I have a group of names that I need to create a measure to return the highest value (ex. 17 in the image below), on number of Frac Days for for the group (top line):

 

 

 

 

 

 

The measure for Frac Days is = DATEDIFF('Well Info'[Frac_Start_Date],'Well Info'[Frac_End_Date].[Date],DAY)

 

How can I best generate that number? I'm fairly new to PowerBI & DAX. Thanks!

  • bheinrich's avatar
    bheinrich
    8 years ago

    The MAXX function worked! I also had to also reconfigure my connections which was another issue. Thanks!

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     Have you tried using MAX in a measure?  So it would be:

     

    Highest Value = MAX( [Frac Days] )

     

    This should bring back the highest value

    • bheinrich's avatar
      bheinrich
      Frequent Visitor
      8 years ago

      Thank you.  I need to set it to return the max number of days for each of my groupings though.   Each name rolls up to a specific group. Does that makes sense?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Oh okay, try using MAXX instead of MAX?