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.

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
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.

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

It works! Thanks!

 

I have not seen (x) => f(x) in Power Query M Reference on MSDN, but probably I did not dig deep enough :-/

 

I still do not understand why solution with "each" works when I am increasing a constant date and does not work with the use of another field to deliver the date to be incremented.