Courses / Power Query (Get & Transform)
10. Remove Columns
Removing one or more columns from a table using the UI or Table.RemoveColumns in M.
Power Query M
Remove Columns
Removing one or more columns from a Power Query table so they no longer appear in the output.
"I only need the customer name and city — drop the rest so my report is smaller."
Table.RemoveColumns removes named columns from a table; in the UI you can also right-click column headers and choose Remove. When removing multiple columns, pass a list of names to Table.RemoveColumns.
"I only need the customer name and city — drop the rest so my report is smaller."
Table.RemoveColumns removes named columns from a table; in the UI you can also right-click column headers and choose Remove. When removing multiple columns, pass a list of names to Table.RemoveColumns.