Max Calculations

[Anonymous]

Hello 

How can we interpret this logic in to Dax calculation.?

SELECT A, max(CHANGEDATE) AS chng_date FROM W.status  WHERE status ='Apples' GROUP BY A

Thanks

RE

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

calculate(Max(Table[CHANGEDATE]), filter(Table, Table[status]="Apples"))

Display with A