Forum Discussion

simon139's avatar
simon139
Frequent Visitor
3 years ago
Solved

Creating a Power Query loop based on 3 columns

Hi Guys,  I am not too good in Power Query / M language so really need your help here. I have a Python script which is working in PQ, but I need to rewrite it to 'M Language' as Power BI GateWay d...
Need Help
Show and Tell
  • HotChilli's avatar
    HotChilli
    3 years ago

    You are pretty close.

    I put this together for the Custom Column:

    Table.AddColumn(#"Changed Type", "Custom",  (row) => 
List.Generate( () => (row[start]), 
each _ <= row[duedate], 
each Date.AddMonths(_,6)))

    start and duedate are dates. I hardcoded the 6 just as an example

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
3 years ago

You are pretty close.

I put this together for the Custom Column:

Table.AddColumn(#"Changed Type", "Custom",  (row) => 
List.Generate( () => (row[start]), 
each _ <= row[duedate], 
each Date.AddMonths(_,6)))

start and duedate are dates. I hardcoded the 6 just as an example

simon139's avatar
simon139
Frequent Visitor
3 years ago

Thank you HotChilli. I got to the point where I can add hardcoded month, but I just do not know how to put that month into variable which is based on value in other column 

  • simon139's avatar
    simon139
    Frequent Visitor
    3 years ago

    Ok I changed the formula and it actually works - thank you so much!! 

    I would appreciate If you would quickly explain what does the (row) => stands for? And why it works with (row) bud it didn't work without it. 

    = Table.AddColumn(#"Renamed Columns", "Custom", (row) =>
    List.Generate( () => (row[start_date]),
    each _ <= row[duedate],
    each Date.AddMonths(_,row[billing])))