Display only month ends in a graph.

[alan_grn]

I have a list of balances that is laoded each day.

I am trying to display in a chart only those balances as at month end.

I have started with this which will give me all the balances. I want to restrict this to month end dates only.

SUM({$<[Business Date]={$(='"<='&DATE(MAX([Business Date]))&'"')}>} [Balance])