cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Need a Max dax formula

Hello,

I need the latest date in "Max Date" column, for a A-E in "Site" column which is "Fully" in "Status" column. In Excel I used IF & MAXIFS.

Thanks

 

SiteDateStatusMax Date
A2/8/2019Fully 
A2/11/2019Fully 
B2/9/2019N. Fully 
B2/14/2019Fully 
B2/15/2019N. Fully 
C2/10/2019Fully 
C2/12/2019Fully 
E2/13/2019Fully 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Need a Max dax formula

@Anonymous

 

Try this formula

 

=calculate(max(Table1[Date]),ALLEXCEPT(Table1,Table1[Site]),Table1[Status]="Fully")
Try my new Power BI game Cross the River

View solution in original post

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Need a Max dax formula

@Anonymous

 

Try this formula

 

=calculate(max(Table1[Date]),ALLEXCEPT(Table1,Table1[Site]),Table1[Status]="Fully")
Try my new Power BI game Cross the River

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors