Pulling through previous entry by line via Calculated Column

[LaurenceSD]

Hi, 

I'm trying to find a method of adding in a calculated column to show a bookings previous DebtorStatus & Category.

So in the example below for 420332 the 7th March I'd want to see Paid as the PreviousDebtorStatus on the 7th March (as this is the DebtorStatus on the 6th March), but the PreviousDebtorStatus  for the 6th of March should read Overpaid (as this is the DebtorStatus on the 28th Feb) and on the 28th Feb the PreviousDebtorStatus should be blank, as there was no data prior to this.

the data is all organised in one table, with one entry per booking, per date (although new bookings will be added all the time and so won't have the historical element).

I've tried using SELECTEDVALUE but to no avail, any insight or solutions would be greatly appreciated

Thanks

Laurence

[Ahmedx · Accepted solution]

Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhiHCJPxTTp6RMFeK?e=j7qbpB