Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to remove all columns after the column that is named "Q3". How should I write this in M?
The number of columns before Q3 is dynamic.
Regrads,
Dave
Solved! Go to Solution.
Insert following statement where you can replace Source with previous step
= Table.RemoveColumns(Source,List.RemoveRange(Table.ColumnNames(Source),0,List.PositionOf(Table.ColumnNames(Source),"Q3")+1))
Insert following statement where you can replace Source with previous step
= Table.RemoveColumns(Source,List.RemoveRange(Table.ColumnNames(Source),0,List.PositionOf(Table.ColumnNames(Source),"Q3")+1))
Works lika a charm! Thank you!