Create a list with a start and an end date

[ThomasWeppler]

Hi Power Bi community

I need to make a list for each row that show how many months have passed.

= Table.AddColumn(#"Filtered Rows2", "Month", each List.Generate(()=>[x=#date(2022,3,18)], each [x]<=#date(2025,6,24), each [x=Date.AddMonths([x],1)], each [x]))

I want to replace [x=#date(2022,3,18)] with the data from my colum Next_invoice_date
and

[x]<=#date(2025,6,24) with the data from my colum Expire_date

Can anyone help me with this?
All help will be greatly appreciated.

[slorin · Accepted solution]

Hi @ThomasWeppler 

= 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]
            )
  )

Stéphane 

[ThomasWeppler]

Thanks a lot for the help. 🙂