Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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   Site Date Status Max Date ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    Try this formula

     

    =calculate(max(Table1[Date]),ALLEXCEPT(Table1,Table1[Site]),Table1[Status]="Fully")
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous

 

Try this formula

 

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