How to Get the Total Benefit for the left over months?

MadhumithaV_26 — Fri, 11 Mar 2022 08:15:39 GMT

Calculation :

Assume a project has a “Total Benefit” per year of £120. The following table shows how to chart the annual benefit depending on the project completion date. Please help me on the DAX formula in achieving the annual benefits for the years 2022 to 2026.

Project completion date	2022	2023	2024	2025	2026	Notes
30Jun22	£60	£120	£120	£120	£120	Benefits start in July 22 = Six months of benefit in 2022 = (£120/12) x 6 = £60
31Oct22	£20	£120	£120	£120	£120	Benefits start in November 22 = 2 months of benefit in 2022 = (£120/12) x2 = £20
31Dec22	£0	£120	£120	£120	£120	Benefits start in January 23 = 12 months of benefit in 2023 = £120
31Mar23	£0	£90	£120	£120	£120	Benefits start in March 23 = 9 months of benefit in 2023 = (£120/12) x9 = £90
31Oct23	£0	£20	£120	£120	£120	Benefits start in November 23 = 2 months of benefit in 2023 = (£120/12) x2 = £20

Please help me in providing the DAX for the following requirement. It would be really helpful.

Thanks in advance !!

Re: How to Get the Total Benefit for the left over months?

littlemojopuppy — Sat, 12 Mar 2022 19:40:50 GMT

MadhumithaV_26 can you share some raw data? Not what you expect the finished product to be

topic Re: How to Get the Total Benefit for the left over months? in DAX Commands and Tips

How to Get the Total Benefit for the left over months?

Re: How to Get the Total Benefit for the left over months?