Power Query: Duplicate Rows, MONTH(TODAY()), and Add to Month For Duplicated Rows

Hello Jpalaci1 !

Step 1 :

1.  Filter 1 :
   • I recommend you to add TODAY() formula in a cell in your worksheet. Then, load this range in Power Query (Select your cell, click on "Data" > "From table"). Today date will be now loaded into Power Query.
   • To use it properly, you will have to add "{0}[Column1]" (drill down) to get a value and not a table. It should look like this "Date.From(Excel.CurrentWorkbook(){[Name="Today_date"]}[Content]{0}[Column1])". 
   • Rename it "Today_date" and use this date for your filter > Table.SelectRows(Step, each [Month]>= Date.Month(Today_date))
2. Filter 2 :
   • Use Date.Month(Today_date) to help you perform this filter

Step 2 & 3 :

1. Step 2 :
   • if you want to duplicate rows for each month, you can create for each row a list which contains month number from month +1 to 12. Example : {1..12} creates a list from 1 to 12.
   • You can use "AddColumn = Table.AddColumn(PreviousStep, "List", each {[Month]+1..12})". You will have a list from Month +1 to 12 in each Row.
   • Then, Expand this new column by using "ExpandColumn = = Table.ExpandListColumn(AddColumn, "List").
2. Step 3 :
   • I don't understand what you would like to do. You can use the same list creation as explained in step 2 to duplicate rows (with {1..12}).

In order to append step 1a, step 2 and step 3 into one table, you can simply use Table.Combine (more info here : https://docs.microsoft.com/fr-fr/powerquery-m/table-combine)

Step4 = Table.Combine({"Step1", "Step2", "Step3")}

Hope it will help,

Nicolas