Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Remove multiple columns in Power Query

Hi, Is there a way to remove multiple columns in Power Query or do I need to remove one each time?   Based on the above image, i'm checking if the column exists, and if it does, I want to re...
Need Help
Tips and Tricks
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    You can intersect the list of columns you want to remove with the existing column names like this:

    = Table.RemoveColumns(
    RenamedColumns,
    List.Intersect(
        {
            Table.ColumnNames(RenamedColumns),
            {"UnitPrice", "TaxRate"}
        }
    )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Could you tell me if your problem has been solved by AlexisOlson 's suggestion? If it is, kindly Accept it as the solution. More people will benefit from it.

 

Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Best Regards,
Eyelyn Qin