I need help to see how I can ungroup/expand rows into the number of rows specified by a column value
for example:
I am here:
Start Date | End Date | Days | Number of Months | Number of Months +1 |
---|---|---|---|---|
3/1/2026 | 5/31/2026 | 92 | 2 | 3 |
6/1/2025 | 6/30/2025 | 30 | 0 | 1 |
8/1/2025 | 9/30/2025 | 61 | 1 | 2 |
I need help accomplishing the following 2 steps:
STEP 1:
Ungroup/Expand into the number of rows specified by “Number of Months +1” EX:
Start Date | End Date | Days | Number of Months | Number of Months +1 | Month List |
---|---|---|---|---|---|
3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 1 |
3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 2 |
3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 3 |
6/1/2025 | 6/30/2025 | 30 | 0 | 1 | 1 |
8/1/2025 | 9/30/2025 | 61 | 1 | 2 | 1 |
8/1/2025 | 9/30/2025 | 61 | 1 | 2 | 2 |
STEP 2:
Assign End of Month value for each row starting with end date and working backwards (EOM(service end date -“Number of Months +1” +" Month list"))
Start Date | End Date | Days | Number of Months | Number of Months +1 | Month List | EOM |
---|---|---|---|---|---|---|
3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 1 | 3/31/2025 |
3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 2 | 4/30/2026 |
3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 3 | 5/31/2026 |
6/1/2025 | 6/30/2025 | 30 | 0 | 1 | 1 | 6/30/2025 |
8/1/2025 | 9/30/2025 | 61 | 1 | 2 | 1 | 8/31/2025 |
8/1/2025 | 9/30/2025 | 61 | 1 | 2 | 2 | 9/30/2025 |