Power Query Challenge: Dynamically Select Last Column (PQC01)

[@DataDashPro]

Happy to see English version video. Please keep it up.

[@AAAExcel]

Thank you 🙏

[@sktneer]

I solved it using the following M Code... let Source = Table.SelectRows(Excel.CurrentWorkbook(), each [Name] = "Data")[Content]{0}, ColNames = Table.ColumnNames(Source), Cols = {"NAME"} & {List.Last(ColNames)}, FinalData = Table.SelectColumns(Source,Cols) in FinalData

[@AAAExcel]

super cool, thank you for sharing your idea's

[@sktneer]

@@AAAExcel Thanks! I'm glad you liked my solution. Your video was a great inspiration!

[@mostafaabdelgaid867]

ربنا يبارك في عمرك وعملك اني احبك في الله

[@AAAExcel]

بارك الله فيك يا مصطفى.. احبك الله 🙏🙏

[@usmaniqbal1836]

جزاک اللہ اخی

[@AAAExcel]

JazakAllah Usman

[@usmaniqbal1836]

@@AAAExcel وایاک

[@kishorpanara4191]

Awesome my dear friend

[@AAAExcel]

Thank you 🙏

[@amaniahmed1474]

we are really proud of you...keep it up

[@AAAExcel]

Thank you so much Amani 🙏🙏🙏

[@latinamericanboy]

Sensational content!!

[@AAAExcel]

Thank you 🙏

[@proswes1017]

let Source = Excel.CurrentWorkbook(){0}[Content], Reqcol = Table.SelectColumns(Source,{"Name",List.Last(Table.ColumnNames(Source))}) in Reqcol

[@TheSandipstar]

sir, need more vedios on English

[@AAAExcel]

Hi, I am posting English videos to another channel, dedicated for English content youtube.com/@aaaexcelenglish

[@pascaljoly5752]

let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", type text}, {"Name", type text}, {"Jan", Int64.Type}, {"Feb", Int64.Type}, {"Mar", Int64.Type}}), Custom1 = Table.ColumnNames(#"Changed Type"), #"Last column" = List.Reverse(Custom1), #"Removed Other Columns" = Table.SelectColumns(Source,{"Name", #"Last column"{0}}) in #"Removed Other Columns"

[@pascaljoly5752]

i simply took a list of the column names using the Table.ColumnNames function. then i reversed the list so that the last item on the list ended up in first position in my list (position {0} since Power query starts counting at 0 and not 1). then i selected the columns i needed (i.e. name and March) and, in the step created, I simply replaced "March" by the name of the list I created (I.e. #"Last column) and selected the first item in this list {0}. worked fine. i then added April only and refreshed and it worked and then i added May and june at once and it showed June when i refreshed. thanks for the challenges. it's fun

[@AAAExcel]

Super - thank you