Using M to dynamically change column names in Power Query

Learn how to use M language to dynamically change column names in Power Query! This is used mainly to clean and transform (e.g. trim, uppercase, etc.) an unpredictable number of messy column names.

Check out our new Power Query fundamentals course!

#powerquery #powerbi #etltools #data #dataanalysis

[fadilyassin]

hi
you are not alone who does not supply the data to practice do you expect people to understand without THE DATA

[extremeautomationwithajayp]

hi there. You know so much about M code. Congratulations for this. I want to ask you one thing which is bothering me so much. In table add column function, i am trying to create a code using list generate and i like to join two columns and this to be continued till i am not done with all columns. I have a challenge in using this table add column function, i want to create a new header everytime it joins the two columns. i see the new column which we write in this function as a name, cannot be a variable. so as a result, it has the same column name and not allowing to join the third and fourth column. Do you have any idea how we can make new column name dynamic so table add column fx should keep creating the new columns without duplicate error

[ddp]

i still don't get how to create dynamic columns so when the data comes in from the file it is automatically updated. it was a great video. I just stuck.

[gospelmoto]

Great video. So much to catch up. But thanks for sharing.

[controlsgirl]

Another great application walk through! I love how you split the video to show the smaller table and how to transform its contents into lists.

[SamehRSameh]

Please zoom in because of font is small

[controlsgirl]

I also love how you explain the variables and the inner/outer environment

[SpiritualMotto]

I need help on changing column name on daily to filter, when i first did my filter on my source column name is [xxx 25/10/2020] and filtered with "5" next day my column name is changed to [xxx 26/10/2020] when i refresh, it shows error like column is not found. Note: i dont want it to rename, i need source header as it is in output as well. I tried using table.columnnames(source){1} to filter based on column index instead of static column name as [xxx 25/10/2020] however, after refresh, it shows table is empty. There is no error but data is not getting populated. I need support to fix this.

[amitk]

Great video and very helpful . very nice way to explain

[larmondoflairallen]

I am blown away! You covered several situations that have always bugged me, things I knew were possible but I didn't know how to write the code for.

[caballero]

I got lost. Sir, at what point did you load Table1? Please explain further I appreciate your help in advance.

[MrDhunpagla]

Hi, I am facing expression error with the last column name in a file in which additional columns added recently. Whenever I refreshing the file in power query getting error since the column size increased by one. Please suggest how I can fix it ?

[mariaalcala]

Great video! well explained and easy to follow!!

[nehakinitya]

How can we create single step for replacing multiple values for example correction of city names

[TY-zlvw]

Thank you for the video. I'm really new to the M language, this video really show there are concepts I need to pick up, for the whole Power Query in the matter of speaking.
I found this video when seeking a possible way of automictically adding an attribute column using table's own name. I have query that already combined several tables scrapped from website. The table name would have something like '2017/2018', '2018/2019'... but content of each table themselves only include months, not the years. In the output I really want something like Jul 2017, Aug 2017....Jan 2018... Dec 2018... for further analysis. I did it manually so far, since that sample was only about 4 years worth individual months. But couldn't help wondering if there is a automatic way of doing it when data size gets large.
I hope I'm making sense.

[malchicken]

Great video, well done. A possibility for another video segment: the different ways to stitch two lists together. I found most interesting the step of the custom column combining the two columns as lists into a combined list. It did make me wonder though, what are the different ways to combine lists together, like I’ve heard of a ‘zip’ function that can alternate values, but this is doing the same thing if those lists were expanded to rows?

[anatulyalmaimany]

You are the best power query teacher on youtube!