Split Project Savings over the next 12 month based on the finish date

[Anonymous]

Dear Power BI Community

I searched for the topic for quit a while now, but since im quit new to PBI und DAX I thought i'm taking the chance to ask the question into the community. Thanks in advance for the help!

What's the situation?

Im using the Microsoft Project Server Contact Pack as a Basis Report. I have projects with a actual savings amount (IST) which I would like to split over the next 12 month, based on the their finished date (SollEndtermin). Which means, if the finish date is within a month e.g february, then I would like to have, that the split of the savings starts with this month -> finish date for example 03/10/2021 -> split over the next 12 month starting in march 2021 until march 2022

the actual data looks like this:

Dimension	Projects	Projects	Projects	Projects
Attribute	Project Name	Project ID	SollEndtermin	IST
	LEAN_WS_Ersatzteil_UC	2020-1645	30.10.2021	100000
			ENG: Actual finish Date	ENG: Actual Savings

current date table:

currently our matrix in Excel looks like this:

[amitchandak · Accepted solution]

@Anonymous , with a start date you can create an end date

new column

end date = date(year([strat date]), month([start date])+12, Day([start Date]))

then refer if this blog can help

How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785