please see the attached approach
first determine the lsat day by code and account
then get the balance on the max date
create the viz and filter for the balance code
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
bank balance.twbx 15.2 KB