Forum Discussion

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

Display by max date

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

    FZOU , Try a measure like

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

FZOU , Try a measure like

 

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