Forum Discussion
Create column by applying date filters
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.
2 Replies
Syndicate_Admin , No very clear
Calculate(Sum(Table[Benefit]), filter(Table, Table[Closing date] <= eomonth(Today(), -1) ))
Thanks for the help
