cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Highlighted
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
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,534)