Add a conditional column with a great complexity

Hello everyone,

I'm having difficulties with a database in Power BI. Attached is a file containing a fragment of the database.

My database translates the state changes of an object in a software ("intlog_intervention" being the object number), and each row indicates the modifications that occur on the object. I have a column that contains information called "Val_new_prio," which indicates the new value after a modification to a field (2: valid, 3: completed, etc.). My goal is to determine the state of the object at the time of a modification (e.g., a date change). Ideally, a new column should provide the object's state at any given moment, regardless of the nature of the modification.

Below you will find a file with a screenshot of an Excel file showing the expected result. The additional column takes its values from the "Val_new_prio" column to provide the state for each row.