Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Getting previous row based on criteria

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?

 

  • Hello Anonymous , 

     

    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 

1 Reply

  • dharmendars007's avatar
    dharmendars007
    Memorable Member

    Hello Anonymous , 

     

    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