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
1 ACCEPTED SOLUTION
Hii!
I got a solution for this question in this website https://gorilla.bi/power-query/change-column-type-by-position/.
Thankksss
@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.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Hii!
I got a solution for this question in this website https://gorilla.bi/power-query/change-column-type-by-position/.
Thankksss
