?? Boost Your Power Query Skills with This Handy Function!

As a Power BI developer, I often work with datasets that have messy column names. To streamline my workflow, I created a custom Power Query function that:? Removes special characters.? Trims leading and trailing spaces.? Replaces spaces with underscores.? Converts column names to UPPERCASE for consistency.

Here’s a quick example of what it does:

Before: " Sales Amount ", "Profit Margin@ "

After: SALES_AMOUNT, PROFIT_MARGIN

This function ensures clean and standardized column names, making your reports more professional and your queries more manageable! ??

// Clean Column Names Function
let
    CleanColumnNames = (Table as table) as table =>
    let
        OriginalColumnNames = Table.ColumnNames(Table),
        CleanedColumnNames = List.Transform(
            OriginalColumnNames, 
            each Text.Upper(Text.Replace(Text.Trim(Text.Select(_, {"A".."Z", "a".."z", "0".."9", " "})), " ", "_"))
        ),
        RenamedTable = Table.RenameColumns(Table, List.Zip({OriginalColumnNames, CleanedColumnNames}))
    in
        RenamedTable
in
    CleanColumnNames        

#PowerQuery #PowerBI #DataCleaning #DataTransformation #BIProfessionals