Select a result to preview

UPPERCASE AND UNDERSCORE COLUMN NAMES

#Power_query #Data

BI and PQ DATA TIPS AND TRICKS

Table.TransformColumnNames( Source, each Text.Upper( _ ) )
// CAPITALIZES All Column Names

Table.TransformColumnNames(UppercasedText, each Text.Replace( , " ", "" ) )
// Replaces all full stops with a space

EXAMPLE IN EDITOR
UppercasedText = Table.TransformColumnNames(#"Renamed Columns4", each Text.Upper( _ ) ),
AddUnderScore = Table.TransformColumnNames(UppercasedText, each Text.Replace( _, ".", " " ))