Rename multiple column names at once in power query

[arjun_para]

I want to rename these columns at once as April 2019, may 2019, June 2019........Sept 2024

[Anonymous]

Hi @arjun_para 

First of all, I need to confirm with you, does your data include all months from 2019 to September 2024? Is there a separate table for each year? 

Could you please tell me the purpose of doing this? The current table structure may not be suitable for subsequent calculations. It is recommended to use unpivot to modify the table structure.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[arjun_para]

yes all months are there from  April 2019 to  Sept 2024, this is imported from an excel file.There is no separate table for each year  

[v-csrikanth]

Hi @arjun_para  

Thanks for using the Microsoft Fabric Community.

Step1: In Power BI, go to Home > Transform Data > Transform Data to open Power Query Editor.

Step2: In the formula bar, you can manually rename columns with the below syntax:

____________________________________________________________________________

= Table.RenameColumns(PreviousStepName, {

    {"April", "April 2019"}, 

    {"May", "May 2019"}, 

    {"June", "June 2019"},

    {"July", "July 2019"},

    {"Aug", "August 2019"},

    {"Sept", "September 2024"}

})

____________________________________________________________________________

Replace PreviousStepName with the name of the previous step in your query.

If the above information helps you, please give us a Kudos and maked the reply as a solution.

Thanks,

Cheri Srikanth