When first starting with Power BI and diving into the Power Query editor you start to realize there are many ways to accomplish the same end goal. For example, if you want to remove columns you can right-click on a column and remove it, hit the remove columns icon from the home ribbon, or even remove other columns. The decision you make to remove the columns though has a consequence. For example, if you use the remove column feature this makes it harder to modify this step in your applied steps. If you chose the remove other columns feature or what I will showcase in my video below, the Choose Columns feature, then you can easily modify the applied step. I believe the Choose columns step is the easiest of them all to utilize when removing columns. Have you ever had a query with a copious amount of columns and you want to quickly go to a column without having to scroll through the whole query? Well, I have the solution for you. In the ...
Sharing my process of transitioning from an Algebra teacher to a BI trainer | if anyone else out there is apprehensive about new technology you are learning or if you are just feeling overwhelmed with whatever the task may be - you can stop by from time to time for some motivation and quick tips.