Columns with different filters for same customer

[Melissa]

Hi @MK3010,

Only used List.Generate here and in Challenge #5
You can review that here and I will do my best to work on more content

Power BI Builds 5 - Optical Data

. Sounds like a nice Power Query challenge In my submission I explored using a recursive function, to return a future date - you can find that here. . The M function below generates a list of dates, so you can extract whatever you find interesting ( myDate as date, dateDOB as date ) as list => let BufferedInterval = Table.Buffer(Interval), curDate = Date.AddMonths( myDate, Table.SelectRows( BufferedInterval, (BT) => BT[Age] = Number.RoundDown( Duration.TotalDays…