Forum Discussion
Referencing columns from previous step dynamically (M Code)
Hi Community, in M, instead of mentioning particular columns in STEP5, I would rather make some reference to previous step. Current: #"STEP4" = Table.SelectColumns(#"STEP3",{"Column6...
You can do
#"Step 4" = Table.ColumnNames(#"Step 3"[[Column 6], [Column 7], [Column 8], [Column 9]])
#"STEP5"=Table.ReplaceValue(#"Step 3"[[Column 6], [Column 7], [Column 8], [Column 9]], null,"",Replacer.ReplaceValue,#"Step 4")
--Nate