cancel
Showing results for
Did you mean:
Highlighted
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.

Any help is much appreciated, thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
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
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 !

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

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?

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 278 members 2,694 guests
Recent signins: