Forum Discussion

BSM1985's avatar
BSM1985
Icon for Helper IV rankHelper IV
5 years ago
Solved

Max Over Partition in DAX

Hi Team,

 

Im trying to create the DAX calculation for below SQL statement. Can you please assist me on this?

 

SELECT MAX(DATE) OVER (PARTITION BY PD, CA ORDER BY DATE DESC) AS MAX_DATE
FROM TABLE

 

Thanks

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    BSM1985 ,

    Try a measure like this and add that to visual

    calculate(max(TABLE[DAte]),allexcept(Table, Table[PD], Table[CA]))

2 Replies