Filter dates Before or equal last month

Roughly like this:

<date>  <=EOMONTH(TODAY(),-1)

Hi aldanab ,

Have you solved your problem? If not, please try this way.
Here is my sample data:

You can use this M function to achieve filter:

= Table.SelectRows(#"Changed Type", each [Date] < Date.StartOfMonth(DateTime.Date(DateTime.LocalNow())))

The output is as below:

And about "It will give acumulative figures for Balance at date of end of month", my understanding is that you want to sum the values for each month. You can follow these steps:
Add two Custom Columns to find the month and year of Date:

And the table is as below:

Then use Group By function:

And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.