How to pick the lastes day of each month(not the last day) at load editor?

[nezuko_kamado]

I'm trying to build a new table that shows [Net] divided by [Cumulative] at Load editor. 

And when choosing [Cumulative],  it has to pick the latest day of each month's value. So here, it has to pick  [Cumulative] of  11/28/2020, 12/26/2020, 1/30/2021, 2/27/2021, 3/27/2021 and 4/24/2021.

Then [Cumulative] values matches with [Month Year] and calcuate [Net]/[Cumulative]

[rwunderlich · Accepted solution]

MonthCum:
LOAD
  Date(MonthStart(To), 'MMM-YY') as MonthYear,
  FirstSortedValue(Cumulative, -To) as Cumulative
Resident Data
Group By MonthStart(To)
; 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com