I have a database with a unique ID identifier for each row/record. Rows are created by dates.
For example, say I have 3 rows for borrower #1 for April 1, May 1, and June 1 and their respective rating.
April 1 = A2
May 1 = A1
June 1 = A1
How would I be able to create a column that would identify if the rating has changed from the previous month? So April 1 = no, May 1 = Yes, June 1 = No.
Any help would be appreciated. Thanks.