Last day of each month line chart

[jdmarlin]

     I have a list of dates from Jan 1st, 2011 to Aug 17, 2016, and I'm trying to create a line chart that will show me the balance at the end of each month. So the balance of Jan 31st, 2011, Feb 28th, 2011, and so on..

The problem is that when I use MonthEnd of YearEnd, etc it sums the balances of Jan 1st to Jan 31st instead of showing me the balance from Jan 31st. I have the same problem using Aggr(Max(Date), Year, Month)

[sunny_talwar]

May be use something like this:

Dimension

MonthYear

Expression

FirstSortedValue(Aggr(Sum(Balance), Date), -Date)