Getting previous row based on criteria

[analyst123]

My dataset contains time stamps, item codes and a user. 

What I am trying to do is add a new column called 'last user' which shows me based on the time stamp and item code, the last user who was associated with the item code. What this would look like is:

Can someone please help me with how I can do this trasnformation in power BI?

[dharmendars007 · Accepted solution]

Hello @analyst123 , 

Please try this approach to get the desired calculated column..

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN