Forum Discussion
Solved
Output based on Latest timestamp
I have this table-
I need to get picker name column in Sales order table in such a way that the name of the picker should be the one picking currently or the one who picked last.
I used the column as -
User Name = var Orderno=SalesOrder[order no]
return
calculate(MAX(History[Picker]),filter(History,History[order no]=Orderno))
but not getting the desired output.
Sales order table
Simple enough,
3 Replies
amitchandak Thanks for this. But, I used your measures as column and it is coming blank as output. I need this to be a column and not a measure as I am further using it for sorting purpose.
Simple enough,
