Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date

I have two columns - quantity and date i want to find the date when max quantity was sold?
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Or do like this.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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

Anonymous , Try this

 

lastnonblankvalue(Table[Qty],max(Table[date]))