Power Query Do While Loop

Hi,   I am trying to replicate a SQL do while loop.   I have a table with customers some are active some are inactive and I need to get the figures for each month end using the created and termin...