You could create a new calculated field and use dateadd function to add one day in your date. If the date changes to the first day of the next month, it would be the last day of the month. Then use filter to get the data you want.
IF DAY(DATEADD('day', 1, [Date])) = 1 THEN
Please refer to the below screenshot where I am trying to get last day of each month.
The only reason for posting another solution to this was makedate() fails when things goes live. So if you are working in live connection, you won't get makedate() function.
I have created a simple calc as below:
you can see I have put it in the filter section as we as text section.Right click and edit the table calculation as per shown in the advanced window in the image. You will get the desired result.
Thanks and Regards,
Last day of month.twbx 346.9 KB