Split a value over next 12 months

Hi GRedhead 

You can try this, 

create a calendar table

Date = CALENDAR(DATE(2022,4,1),DATE(2023,7,1))

create a YM column, 

YM = FORMAT('Date'[Date],"yyyy-mm")

create 2 colums [Opp 1] & [Opp 2],

OPP1 = 
var _start=DATE(2022,4,1)
var _value=12000
var _end=EOMONTH(_start,11)
return IF('Date'[Date]>=_start&&'Date'[Date]<_end && DAY('Date'[Date])=1,_value/12)

OPP2 = 
var _start=DATE(2022,6,1)
var _value=12000
var _end=EOMONTH(_start,11)
return IF('Date'[Date]>=_start&&'Date'[Date]<_end && DAY('Date'[Date])=1,_value/12)

create a total measure

Measure = MIN('Date'[OPP1])+MIN('Date'[OPP2])

result

I also find 2 posts related for your reference,

https://community.powerbi.com/t5/Desktop/Splitting-values-equally-into-Months-based-on-the-Start-and-End/td-p/2232329

https://community.powerbi.com/t5/Desktop/Splitting-period-data-into-months/m-p/113861

hope they will help.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.