Equal Split Over Period

[CalvinA]

Hi!

I posted this in the Tableau forums but was told it needed an ETL solution.

I have a Start date, an End date and a Revenue number. I'd like to be able to split the revenue number equally over the months between the start date and end date for each Order. For example:

Order: 1

Start date = '2017-06-06'

End date = '2017-12-04'

Revenue = 28,000

Jun: 4000

July: 4000

Aug: 4000

Sep: 4000

Oct: 4000

Nov: 4000

Dec: 4000

Thanks!

[patrick_digan · Accepted solution]

@CalvinA I think the attached should do the trick. I'm using the generate rows tool to split it out. 

[CalvinA]

Amazing. Thanks a lot Patrick. Learned several new techniques from your solution also.

[Vijay_kumar7]

Hi Patrick, 

i have slimier problem and solution is not giving me correct results as it is not considering the case in start date June and end date is July. in these cases it is coming empty.