Get a column value based on the last day of month

I have attributes ‘date’, ‘account_balance’. I want to display the account balance of last day of each month.
NOTE: Not the maximum account balance in each month BUT the last day balance of each month
I tried last_value and did not get the results that I’m expecting
Any help is appreciated

Hi @likhitha
what did you try, get and do you expect?

@likhitha -
Did you solve your issue? If not, can you please provide more details as to the calculation you are using, the result and the expected result in screenshots.