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?
BR

@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.

Hello @likhitha, since we have not heard back from you, I am going to unlist this question. If you would still like assistance with this or a different issue, please post a new topic in the community. That will ensure you are at the top of the priority list to receive a response from a QuickSight expert. Thank you!