7 Power Query Tricks You’ll Regret Not Knowing

and get 4 hours of bonus lessons worth $150 absolutely free!

In this video, I’m sharing 7 useful Power Query tricks you wish you knew sooner! Learn how to use Text.Trim to remove unwanted characters, handle missing columns with MissingField.Ignore, and create custom sorting orders.

I’ll also show you how to combine column transformations, find missing rows between tables, filter data using errors, and dynamically remove empty columns. These are super handy and surprisingly simple tricks in Power Query that will save you a ton of time!

===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -

✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step-by-Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!

[terrylee]

For those watching, I advise you to buy the book. This guy is a YouTube diamond.

[Special_Excel_F_and_L]

This video is really nice ! Soo useful. The remove matching rows is something I need to use. Damn, I was merging rows and keep non match, to add new rows to a table. I think this one will run faster.

[stretch]

Thanks Chandeep! One of the first things I do in a new query is to add the step below to handle the Trim, Clean, and replace errors with null all in one step. I'm sure it can be improved, but it dynamically gets the column names so it works with any new workbook I'm creating. You can insert a new step after Source and just drop it in. I always add it as one of the first steps before the proper data types have been declared.

= Table.TransformColumns(
Source
List.Transform(
Table.ColumnNames(Source),
each {
_,
(value) =>
try
if Value.Is(value, type text) then
Text.Trim(Text.Clean(value))
else
value //Depending on the data I might return the original value, or I'll switch it and return it as text with the line below
//Text.From(value, "en-US")
otherwise
null,
type text
}
)
)

[ItsMeFromD]

Feeding Power Query with what it eats, feeds you and me as well :-) Thank you, Chandeep! Already bought the book and love it.

[bobbysilver]

I love your method of teaching. You are clear, concise and you don't go too fast or get too complicated too quickly.
I have just ordered your book 🙂Keep up the great work.

[sherryizzie]

Thanks for sharing! I've learned so many advanced Power Query tricks from you. I’ve already purchased the book and can’t wait to dive in and master all the tips😊.

[_symmetry_]

I think I never bought an ebook this fast!! Did not even know there was 150$ bonus with it! Can't wait to get the email and read it, this is I'm sure going to be absolute gold!!! Take care and thank you!!

[scotolivera]

you deserve all the support, I just bought the e book

[Riccardo_B]

This book is fantastic and sooner I'll enrol your Power Query course 👍👏👏👏

[AnishSheth]

I just bought your book. A little too late I guess for the bonus but it is a brilliant book from a brilliant author, so definitely worth every penny. Yet to receive the hard copy but the pdf looks wonderfully laid out and very simple to understand

[christopherhazel]

You are one of my go-to experts on M. Of course I ordered the book! :)

[xwalkerm]

This is excellent stuff, i love the ability to put logic into row selection, i have always created helper true/false columns and then filtered, adding unnecessary steps. Thanks so much

[nyobalingit]

Your videos really helped me out when i was starting out and even now. I hope to have a hard copy of your book here in the Uk. I have purchased your digital copy and it is a gem!!!

[OMAKEM]

Thank you very much Chandeep,
Regarding the trim function, how to delete a text instead of the same character.

[automateboringstuffwithraj]

These tricks videos are super exciting whether it's about power pivot, pivot table, power query. Loving it❤

[williamarthur]

Loved the default column type and the sorting .

[rocketrod]

As always awesome content!! I've been a long time subscriber of your channel. I ust purchased the book and look forward to advancing my M coding skills!

[munikumarpoosala]

wow...nice video...keep rocking ...Thanks alot

[masoodmd]

Hello there i just bought your book, hope it will help me a lot, waiting for the digital copy

[RichardJones]

Love the custom sort mention. mind is blown