Add a Column with most recent value

Hello 

Sorry abouth the delay.

My approach to you:

if [Date] = List.Max(#"Changed Type"[Date]) then [ID] else null

the ideia is to find do max of the date e the return de respective ID ,

after you make a Fill Up, 

I hope that's it

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Best Regards
BC

Hi seenai 

Download this PBIX file with the following code

As an alternative, you can do this in 1 line without needing to fill up:

#"Changed Type"[#"Base-HardenerCode"]{List.Count(#"Changed Type"[#"Base-HardenerCode"])-1}

You just need to change the reference to the previous step from #"Changed Type" to whatever the step name is before where you insert this line into your code.

Regards

Phil