Dynamic Columns

[GoatTracker]

I'm wanting to add about 20 columns to a table (Column1 - Column20) all with the same formula as displayed below, any help will be appreciated. At the moment I'm doing this one line at a time 🤔

Table.AddColumn(#"Expanded Date Dimension1", "Column1", each if [MonthStart]<=0 and [MonthEnd]>=0 then " " else "")

Thanks for you help

[CNENFRNL · Accepted solution]

= List.Accumulate({1..20}, #"Expanded Date Dimension1", (s,c) => Table.AddColumn(s, "Column"&Text.From(c), each if [MonthStart]<=0 and [MonthEnd]>=0 then "x" else "y"))

[GoatTracker]

Sorry, this duplicates the rows, it appears to add hundreds of rows.

[VijayP]

@GoatTracker 

In advanced editor you can paste this code 20 times with different step names  and column names!