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
Download a copy of the files used in this video: https://share.getcloudapp.com/NQulQg19
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#powerquery #excel #powerbi