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 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. 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     Post your answers (M Code and the snapshot of the result in the comments below).   Solution Video     .        Automate repetitive data cleaning tasks using Power Query A comprehensive course to learn Power Query to automate all your mundane and repetitive data cleaning tasks in Excel or in Power BI   DOWNLOAD THE COURSE OUTLINE    |    ENROLL IN THE COURSE