Return Last Known Balance for each Account

Hi!   I have the following data:   Table name: Reconciliation Date ID Account ID   Balance   20240101   A 100 20240201 A 200 20240301 B 300 I also have a date table conn...