Need a Max dax formula

[Anonymous]

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
A	2/8/2019	Fully
A	2/11/2019	Fully
B	2/9/2019	N. Fully
B	2/14/2019	Fully
B	2/15/2019	N. Fully
C	2/10/2019	Fully
C	2/12/2019	Fully
E	2/13/2019	Fully

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this formula

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