Return last day of each moth in the calendar

Question

I have multiple records that shows for each month. For e.g. October is showing 15 records and February is showing 12 records. I only want the last record of each month i.e the last record.

Answer 1

Try this way:

Place the order date in the same date format and change the property to 'discrete'

Now extract the year and month in separate calculated fields and drag to detail.

Year:

year(Date) 

Month:

Month(date)

Now create one more calculated field and use this:

WINDOW_MAX(MAX([Order Date]),FIRST(),LAST())