Split Rows by Condition

[tejapowerbi]

Happy Friday Everyone,
I have a below scenarios where I want to split rows (not column) based on condition. If the Month column has <12 then only rows required but if it is 12 month then 2 Rows required,15 month then one row with 12 months and one row with 3 months and if it is 24 months then split two rows in 12 months and 36 months then split 3 rows in 12 months and so on..Can any provide any suggestion?

start	end	months
1/1/2014	1/1/2015	12
1/1/2014	1/1/2016	24
1/1/2014	1/1/2017	36
1/1/2014	1/1/2015	7
1/1/2014	1/3/2015	15

<tbody>
</tbody>

start	end	months
1/1/2014	1/1/2015	12
1/1/2014	1/1/2015	12
1/1/2014	1/1/2015	24
2/1/2015	31/1/2016	24
1/1/2014	1/1/2015	36
2/1/2015	1/1/2016	36
2/1/2016	31/1/2017	36
1/1/2014	1/1/2015	7
1/1/2014	1/1/2015	15
2/1/2015	1/3/2015	15

<tbody>
</tbody>

 

[tejapowerbi]

Hi Peter,
I just want to share a good news with you.
Finally your suggested code is in production and it is splits more than 900,000 rows successfully without a single error.[FONT=q_serif]
Thank you so much for your great Help.

[/FONT]