Forum Discussion
Solved
Custom Column Selection with Multiple Criteria
Hello, I have a file i pull from that updates when a new period is finished. instead of having to manually update my power Query to pull in the new column. I want it to be dynamic. So i wan...
Simply add the List of fixed names to your Selection:
= List.Select(Table.ColumnNames(#"Promoted Headers"), each Text.StartsWith(_,"20")) & {"Territory","Customer","etc"} in
Simply add the List of fixed names to your Selection:
= List.Select(Table.ColumnNames(#"Promoted Headers"), each Text.StartsWith(_,"20")) & {"Territory","Customer","etc"}
in