tejapowerbi
New Member
- Joined
- Nov 30, 2018
- Messages
- 19
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?
<tbody>
</tbody>
<tbody>
</tbody>
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>