Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
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
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

Try this formula

 

=calculate(max(Table1[Date]),ALLEXCEPT(Table1,Table1[Site]),Table1[Status]="Fully")

Regards
Zubair

Please try my custom visuals

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

Try this formula

 

=calculate(max(Table1[Date]),ALLEXCEPT(Table1,Table1[Site]),Table1[Status]="Fully")

Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.