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
@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...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
