Function: Would you like to clean multiple columns in a single operation? This custom step allows you to clean as many columns as needed. Remove extra spaces, remove non-printable/control characters, like line feeds (#(lf)), carriage returns (#(cr)), tabs, etc. Custom Column in applied steps Power Query code that you will use in the Custom Column (or inline custom step). Just reference your previous step in "Source.." (best practice is to rename steps in applied steps window,

PRACTICE MATERIAL BELOW!👇 Function: Would you like to rename multiple columns in a single operation? This custom step allows you to rename as many columns as needed. You need one mapping table (let's call it "RenameTbl") with columns: OldName and NewName, and then reference it simply with a Custom Column step. Yellow markings indicate the difference between Old and New Columns after the custom step. Custom Column in applied steps Power Query code that you will use in the Cus

In today’s data-driven world, knowing how to analyze and understand data is more critical than ever. Two prominent players stand out for those eager to learn: Power BI and Excel. Both tools are widely utilized, yet they have distinct strengths and applications. If you’re trying to decide which one to learn first, this guide will help you make an informed choice. Let’s explore each tool in detail, highlighting its features and benefits, to help you determine the best starting

Getting started with Power BI can feel overwhelming, especially if you're new to data visualization tools. But don’t worry! This blog...

Excel is one of those magical tools that can turn your data chaos into something organized and neat. But navigating its features can feel...

Remove Empty Rows and Columns from tables by using Power Query custom functions. No need to load empty columns anymore.