cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jure_rak Frequent Visitor
Frequent Visitor

Changing multiple columns names

Hi all,

 

I have got data that have 12 columns for months with the abbreviated month name - Jan, Feb, Mar etc. Previously, I just did not bother and manually changed these to be 31.1.2019, 28.2.2019 etc., than did "unpivot columns".

 

But as I have more and more reports, this manual approach has become inefficient, would you be able to advice me how to automate this process?

 

Thanks,

 

table.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Changing multiple columns names

Unpivot the columns first, then append “-2019” to the month names, then convert them to dates



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Changing multiple columns names

Unpivot the columns first, then append “-2019” to the month names, then convert them to dates



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

jure_rak Frequent Visitor
Frequent Visitor

Re: Changing multiple columns names

Sorry for my ignorance, the append "-2019", how could I do it? Still in the editor, I presume, right?

jure_rak Frequent Visitor
Frequent Visitor

Re: Changing multiple columns names

Got it, -> Add Columns, Format, Add Suffix

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 159 members 1,659 guests
Please welcome our newest community members: