Forum Discussion

FRV's avatar
FRV
New Member
1 year ago
Solved

Latest Item in a replace by chain

Hi all, I really need some help as I am struggling to get to get what I need. I want to find the latest item in a replace by chain. I tried doing it with a calculated column but that doesn't work ...
Need Help
  • speedramps's avatar
    speedramps
    1 year ago

    Hi   FRV

     

    Try this easy method ...

     

    Clean your data and add the mssing rows and column, otherwise you will get an error message

     

     

    Add a calculated DAX column  (not Power or a measure) It must be calculated column 

    Path = PATH( yourdata[Item], yourdata[Replace by] )

    Note that the first item in the path is the answer you want

     

    Create another calculated colum to retrive the answer  (it must be calculated column and not a measure)

    Answer = PATHITEM(yourdata[Path],1)

     

     

    Please click thumbs up because I have tried to help.

    Then click accept solution if it works (you can see that that it does work).

     

    Learn more about the PATH function here https://www.youtube.com/watch?v=EzfLJFEKV8I

     

     

     

     

FRV's avatar
FRV
New Member
1 year ago

I am stunned... It's this easy. I was caught in an endless loop of difficult solutions and couldn't make it work in a single calculated column. Also didn't know about the PATH function. Many thanks for your help!!! You saved my life.

speedramps's avatar
speedramps
Super User
1 year ago

Thank you FRV 

 

If you give a person a fish, you just give them a meal.

If you teach them to fish, then they can feed themselves and teach their friends and family.

 

Incidentally, well done on asking the question clearly and concisely with example input data and desired output.

I wish everyone did that !