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
  • amitchandak's avatar
    5 years ago

    Anonymous , Try a measure like

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

     

    Display with A