how to get the latest name from the Month

[Niru]

Hello All,

How to pull the latest name from the Risk Rating field. i need to update same name for all the months.

kindly help me.

Data:

_close_of_business_date	ID	Risk Rating
2020-10-31	116560	Heightened
2020-11-30	116560	Heightened
2020-12-31	116560	Expected
2021-01-21	116560	Expected

Expected Output:

_close_of_business_date	ID	Risk Rating	Latest_Risk Rating
2020-10-31	116560	Heightened	Expected
2020-11-30	116560	Heightened	Expected
2020-12-31	116560	Expected	Expected
2021-01-21	116560	Expected	Expected

Regards,

NK

[Emil_Kos]

Hi @Niru,

It looks like we got information about it:

The previous month indicates the change name. If this isn't something that you are looking for please share the expected output. 

[Niru]

@Emil_Kos Yes, there is some small change im looking, how we gonna display information as like below. Any suggestions please. 

[Emil_Kos]

Hi @Niru,

I have added a new column to the data called when it changed. 

II think it might be something that you are looking for. Not sure what is your whole data set and how many risk rating you gots but it works for this data set that I have. 

[Niru]

@Emil_Kos  Thanks a lot, i got the expected solution. thanks again