PowerQuery Solution: Dynamically Select Last Column, UI& MCODE, you won't imagin how simple!!(PQC01)

[@linhtut2075]

I appreciate you teach power query lessons. I'm watching you from Myanmar, know as Burma. Those challenges are the best to use for me.

[@AAAExcel]

Welcome to my colleagues from Myanmar 🇲🇲 Thank you much following my channel, waiting your attempts to solve .. best of luck and greetings from Egypt 🇪🇬

[@urlyricsv9915]

Practice makes perfect! I'm watching you from Morocco Mister Amrou and I think those challenges are the best to truly test ourselves concerning PowerQuery! Unfortunately, I can't participate for the moment because I just finished the beginners playlist, but I'm 100% that I am coming back to watch them all! Thank you very much

[@AAAExcel]

Thank you for following me and thank you for your comment, regards to the sweet people of 🇲🇦 Morocco

[@DrK99999]

Lovely...Sweet and Simple.👍😀👌

[@AAAExcel]

Thank you 🙏

[@ShafiqUrRehman-b2s]

Great Experience you have. I appreciate your workings

[@AAAExcel]

Thank you, so nice of you

[@anek1945]

Thank you for the lesson, greatings from Poland:)

[@AAAExcel]

My pleasure!

[@eduardomunoz2764]

Great, great video and great solutions. Greetings and thanks

[@AAAExcel]

Thank you 🙏

[@altafhussainbakhwani3847]

Wonderful presentation

[@AAAExcel]

Thank you 🙏

[@MrDhunpagla]

You are absolutely genius ☺️

[@AAAExcel]

Thank you 🙏

[@SantiagoMolero]

Awsome. As always, super easy to understand. You're the best. Thank you!!

[@AAAExcel]

Thank you, happy that you like it

[@kishorpanara4191]

You are great dear

[@AAAExcel]

Thank you 🙏

[@karimamr4389]

🔥🔥🔥

[@AAAExcel]

🤩🤩🤩

[@ahmed.sarhan84]

The solution with one step : List.Last(Table.ColumnNames(Source) to extract last column name = Table.SelectColumns(Source , {"Name" , List.Last(Table.ColumnNames(Source)) } )

[@kaseymorris1917]

Hi Amr, Great video! I followed each step but I would like to use List.LastN to get last 32 columns. I am running into problems, could you advise were I am going wrong? Much appreciated.

[@AAAExcel]

Good question, i took me sometime to guess what could be the error. Acutally when you use the List.LastN, i produce a list of values not a single value. I assume that you want to have the first column with the last 32 column, so you need first to combine the 2 lists: 1- the Name of the first column 2- the names of the last 32 columns to combine 2 lists you man use List.Combine function for example: CombinedList=List.Combine({{"FirstColumnName"},List.LastN(Table.ColumnNames(Soruce),32)}) then when you use Table.SelectColumns, you have to provide one list of all names as per the below FinalStep=Table.SelectColumns(Soruce, CombinedList)

[@vinoselva2468]

How to rename the last column dynamically please?

[@AAAExcel]

Thank you for your comment, i will think about it and I may post a video to explain

[@santronair]

Good 9ne

[@AAAExcel]

Thank you 🙏