Generate Dates in Rows between Start and End Date – Power Query Challenge

Howdy folks!

Here is an interesting and probably challenging Power Query puzzle. Time to shine your grey cells!

Consider this Simple Data

Each customer is pledging a monthly amount for the duration between the start and end date.

The Problem

Generate rows for each month between the start date and end date

Conditions

1. The Investment will be collected on the Start Date and then on the 1st of each month for the following months until the End Date.
2. The date column in the output will either be the start of Investment Date or 1st of the Month.

Expected Output 

Here is how the output should look like. I’ve generated a sample for Customer 125

Download Data

Post your answers (M Code and the snapshot of the result in the comments below).

Solution Video

Download Solution