Forum Discussion

MichaelW's avatar
MichaelW
New Member
10 years ago

How to format column header only (not data)?

Most of the columns in my Excel file have the date as a heading (formatted Mmm-YY in Excel).  They initially appear in the Power BI query as M/D/YYYY, but when I select "Use First Row as Headers" the...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

The M code for renaming columns is:

 

    #"Renamed Columns" = Table.RenameColumns(#"PreviousStep",{{"OldColumnName", "NewColumnName"}}),

Probably be a little more efficient to go into the Advanced Editor and copy and paste the rename columns M code.