Creating Rows -Adding Dates

Hi jerryr125 ,

speedramps has provided a perfectly good solution already, but I think you'll find this alternative a bit simpler, and it will keep your query a bit cleaner as it's just one step to create the list.

Use the following formula in a new custom column:

List.Distinct(
    List.Transform(
        {Number.From(Date.AddMonths([Category Date], -11))..Number.From([Category Date])},
        each Date.StartOfMonth(Date.From(_))
    )
)

Once you expand the resulting list, you get the following output:

Pete