Dynamically remove columns that contain a specific word in the header - Power Query

It is very common when importing data from excel or pdfs that you get a lot of empty columns. In today's video I will show you how to remove those columns dynamically using power query.

Here you can download all the pbix files:



SUBSCRIBE to learn more about Power and Excel BI!





Our PLAYLISTS:

- Join our DAX Fridays! Series:

- Power BI dashboards for beginners:

- Power BI Tips & Tricks:

- Power Bi and Google Analytics:



☼☼☼☼☼☼☼☼☼☼



POWER BI COURSES:



Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:





☼☼☼☼☼☼☼☼☼☼



ABOUT CURBAL:

Website:

Contact us:



▼▼▼▼▼▼▼▼▼▼



If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:







Many thanks in advance!



▲▲▲▲▲▲▲▲▲▲





************



What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!







************





QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:

Linkedin ►

Twitter ► @curbalen, @ruthpozuelo

Facebook ►



#CURBAL #SUBSCRIBE

Power bi,powerbi,Curbal,power bi desktop,power bi tutorial,power bi training,power bi for beginners,ruth pozuelo,dynamically remove columns that contain a specific word,dynamically remove columns in power query,remove columns in power query that contain the word column,curbal power bi,power query,