Date

[notabhish3k]

I have two columns - quantity and date

i want to find the date when max quantity was sold?

[v-lionel-msft · Accepted solution]

Hi @notabhish3k ,

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]

@notabhish3k , Try this

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