Create column by applying date filters

[Syndicate_Admin]

Hello Good morning I am new to the community, I appreciate your help with the following:

I have a column with the benefits of some projects, and another column with the date the project was closed, I need to add a column that shows me the benefits of the projects that were closed during the current year until the previous month, I have tried several ways but I go to the community since I have not found the solution.

Example

Project	Benefit	Closing date	Benefits until the previous month (This is the one I do not know how to get out)
A	10	17/01/2023	10
B	20	20/02/2023	0
C	15	15/12/2022	0 (you should not add it to me xq is not from the current year)
D	30	13/01/2023	30

In this scenario I assume that the current month is February and therefore it will show me the benefits that have been achieved until

January, but in the month March the Column "Benefits to the previous month" should show me the benefits of January and February and so on.

It is worth clarifying that I also have projects from previous years but I am only interested in seeing the year 2023.

Thank you in advance for any help, guidance you can give me.

[Syndicate_Admin]

Thanks for the help

[amitchandak]

@Syndicate_Admin , No very clear

Calculate(Sum(Table[Benefit]), filter(Table, Table[Closing date] <= eomonth(Today(), -1) ))