How do I add a number of months equal to the value in a colum?

[ThomasWeppler]

Hi Power BI Community

I have this column generates a list of months between two dates.

However I want the list to be diffrent based on a value called periodes that determines how many months the list should jump between each row.

Now I have this code.

= Table.AddColumn(#"Filtered Rows2", "Month",
(r) => List.Generate(
()=>[x=r[Next_invoice_date]],
each [x]<=r[Expire_date],
each [x=Date.AddMonths([x],1)],
each [x]))

But I want the number 1 to be repalce with the value in a colum called Period

Does anyone knows how to do that?

All help will be greatly appreciated.

[slorin · Accepted solution]

@ThomasWeppler 

1 --> r[Period]

r = actual row

= Table.AddColumn(#"Filtered Rows2", "Month",
(r) => List.Generate(
  ()=>[x=r[Next_invoice_date]],
  each [x]<=r[Expire_date],
  each [x=Date.AddMonths([x],r[Period])],
  each [x]))

 Stéphane

[ThomasWeppler]

Thanks again. 🙂