spread revenue over future months

[tmears]

I am struggeling on this one.   have a data table which contains revnues recieved however some refer to monthly revenue and some relate to quarter.  My thought is to create a new table which based upon the period calculates revenue over the period

Example:

Sale Date = Jan 19

Period = Monthly

Revenue = 1200

Defer results:

Jan = 100

Sale Date = Jan 19

Period = Quarterly

Revenue = 1200

Defer results:

Jan = 400

Feb = 400

Mar = 400

i have a revenue column, recieved date, and period (which contains, Annual, 6 months, Monthly, One off and Quarterly)

seems simple but struggling, any help out there would be really apprpciated

My model....I have a date table...and a fact table.  Very basic