Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Max Calculations

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

  • Anonymous , Try a measure like

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

     

    Display with A

1 Reply

  • Anonymous , Try a measure like

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

     

    Display with A