Filter dates Before or equal last month

[aldanab]

I would like to filter a column that  only contains data until the last day of the last month. 

Also I can say all data before current month. 

It will give acumulative figures for Balance at date of end of month . 

[lbendlin · Accepted solution]

Roughly like this:

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

[Anonymous · Accepted solution]

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.

[aldanab]

Thank you !! I made it work with this filter 

[lbendlin · Accepted solution]

Roughly like this:

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

[aldanab]

I couldnt make it work with this. But I finally found it simply, It will work for some years , but not for ever 😂 :