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
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)