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?

[TABLE="width: 225"]
<tbody>[TR]
[TD]start
[/TD]
[TD]end
[/TD]
[TD]months
[/TD]
[/TR]
[TR]
[TD]1/1/2014
[/TD]
[TD]1/1/2015
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD]1/1/2014
[/TD]
[TD]1/1/2016
[/TD]
[TD]24
[/TD]
[/TR]
[TR]
[TD]1/1/2014
[/TD]
[TD]1/1/2017
[/TD]
[TD]36
[/TD]
[/TR]
[TR]
[TD]1/1/2014
[/TD]
[TD]1/1/2015
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]1/1/2014
[/TD]
[TD]1/3/2015
[/TD]
[TD]15
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 225"]
<tbody>[TR]
[TD]start
[/TD]
[TD]end
[/TD]
[TD]months
[/TD]
[/TR]
[TR]
[TD]1/1/2014
[/TD]
[TD]1/1/2015
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD]1/1/2014
[/TD]
[TD]1/1/2015
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD]1/1/2014
[/TD]
[TD]1/1/2015
[/TD]
[TD]24
[/TD]
[/TR]
[TR]
[TD]2/1/2015
[/TD]
[TD]31/1/2016
[/TD]
[TD]24
[/TD]
[/TR]
[TR]
[TD]1/1/2014
[/TD]
[TD]1/1/2015
[/TD]
[TD]36
[/TD]
[/TR]
[TR]
[TD]2/1/2015
[/TD]
[TD]1/1/2016
[/TD]
[TD]36
[/TD]
[/TR]
[TR]
[TD]2/1/2016
[/TD]
[TD]31/1/2017
[/TD]
[TD]36
[/TD]
[/TR]
[TR]
[TD]1/1/2014
[/TD]
[TD]1/1/2015
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]1/1/2014
[/TD]
[TD]1/1/2015
[/TD]
[TD]15
[/TD]
[/TR]
[TR]
[TD]2/1/2015
[/TD]
[TD]1/3/2015
[/TD]
[TD]15
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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]