Display by max date

[FZOU]

Hello,

i want to display the comment based on slicer by category and max date, max time, below an example :

For Exp if i choose "Bike" on slicer it should display "OK 2"  because he have max date and maxe time.
Any one can help with this dax formula please ? thank you every one 🙂

[amitchandak · Accepted solution]

@FZOU , Try a measure like

measure =
var _max = maxx(allselected(Table), Table[salesdate])
return
calculate(max(Table[comment]) , filter( Table, Table[salesdate] = _max))