Power Query Editor (Excel and Power BI): Choose Columns v Remove Columns. Which is Better?

Want a more efficient Data Model or Worksheet? One way to get one is to reduce the number of columns of data and if you're familiar with The Query Editor in Excel or Power BI, you've probably seen or used the Remove Columns button. But when it comes to deleting columns, there's a better way - the Choose Columns button.

So what's the difference? Is it just two ways to do the same thing or is one way better than the other? Watch this video to get the answers you need!

This video assumes that you are familiar with the basics of The Query Editor in Excel and/or Power BI

For full details see the timestamps below:

⏱ Timestamps
00:00:00 Introduction
00:00:40 The Problem to be Solved
00:00:56 The Remove Columns Button
00:02:34 Editing the Generated M Code
00:03:49 The Choose Columns Button

🗒 Notes and Resources

✅ Want more FREE training?

🙋‍♂️ Let's connect on social

#powerquery #excel #powerbi

[voksencorporatetrainings]

Wow this is excellent Mike I appreciate your efforts and its useful