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

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?

Highlighted
jure_rak Frequent Visitor
Frequent Visitor

Re: Changing multiple columns names

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

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)