Forum Discussion

mzrkwcz's avatar
mzrkwcz
Icon for Helper I rankHelper I
9 years ago
Solved

Generating a list of months problem

I need to generate a list of dates having: - [start_date] - [number_of_months]   I tested that this works fine: List.Transform({0..[number_of_months]-1}, each Date.AddMonths(DateFrom("2017-05-05...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Out of my head (so not tested), I'm pretty sure this should work:

     

    List.Transform({0..[number_of_months]-1}, (x) => Date.AddMonths([invoices_start],x))

     

    By using (x) => instead of each, you can refer to the list item (i.e. the number) within the Date.AddMonths function.

prathy's avatar
prathy
Icon for Advocate III rankAdvocate III
9 years ago

Hi,

 

Can you try casting _ as number
something like this - List.Transform({1, 2}, each Date.AddMonths(Date.From("10/02/2017"), _ as number))

 

P