Forum Discussion
Rename columns with weekday dynamic
Hii Guys!
I have this excel base, where the columns will always be today + 8 days ahead. So she changes every day.
Would it be possible to get these columns dynamically and rename them with the weeday name, directly in the power query?
Thanksss
Hii!
I got a solution for this question in this website https://gorilla.bi/power-query/change-column-type-by-position/.
Thankksss
2 Replies
- Greg_Deckler
Community Champion
Anonymous Well, if they are going to change all the time, then I would not promote them as headers and work with the default Column1, Column2, Column3, etc. for starters. Then, yes, you should be able to rename the columns based upon the current date and the number of the column. Alternatively, you again don't promote headers and unpivot them and then do find and replace essentially.
Hii!
I got a solution for this question in this website https://gorilla.bi/power-query/change-column-type-by-position/.
Thankksss
