Thank you! Just what I needed to make sure newly-processed data merge correctly with prior date ranges (always expanding with new data)

Dude, I was looking for something like this now in 2023, I asked chatGPT and it made me waste 3 hours with wrong codes, this explanation fixed everything in just 15 min. Thanks!

You really saved my life with that training video. Thank you so much my friend.

Great walkthrough and explanation!

Thank you Sir. I hope can learn a lot of power query from you👍

Thankyou very much, you are very patient in the way you explain and is easy to understand by all levels of expereince

You saved the day, thank you!

Thanks I'm new here

Thanks for this explanation. I have created a function that will do this step: (Source as table, fieldName as text) => let /* Source = #"Input (GroupBy)", fieldName = "myTable", //*/ #"Expanded myTable" = Table.ExpandTableColumn(Source, fieldName, List.Skip( Table.ColumnNames(Table.Column(Source, fieldName){0}), 1), List.Skip( Table.ColumnNames(Table.Column(Source, fieldName){0}), 1)) in #"Expanded myTable"

Very good video and great tip!

Awesome solution! This is exactly the answer I was looking for. Thanks! 😁

Excellente video mate! well done, well explained. The intro was very inviting to watch the rest of the tutorial! 👌👌👌

This is very much clear and nicely explained. Thank you so much for this video. Much appreciated. Also would like to mention that, audio volume is bit low, and the video focusing is also have some problem. Unable to see the text on the screen as it appears like lack of focus.

Super useful! I was wondering how can I apply this not to a single table, but a table full of tables? Like: [Content] [Table] [Table] [Table] (…) Probably it should use Table.TransformColumns along with Table.ColumnNames, but i cant figure it out.

Hi, Very good. Please i am Trying to find an example for Cartesian Product in Power Query. Multiple tables with multiple column in the same workbook, with some equal transformation and some diferents. Any example please. Tks in advance

Hi, I am trying to watch the video but the data and formulas are blurred.

Hello Sir, Please help me on my query. I have changed column header based on list it is working but not working in power bi dashboard. When i update source list then header has been changed in table but visual throwing error like" This can not be used it is invalid column". How can i fix it. Please reply me. Thanks

Much appreciated, thank you! I thought there was an interesting alternative solution presented by kzfaq.info/get/bejne/nr9mg5h-yanRqp8.html recently. But your code extracts the column names from the start and avoids combining whole tables, so it seems like it would be better for performance. I like how your removed potential repeat headers in this videos solution as well with List.Skip. I think thats missing in the blog and the 'increased complexity' solution could use something similar to check for 'columns already present to remove or not expand out'. Also related: kzfaq.info/get/bejne/muCKrK-SqL6Ypp8.html I enjoyed this videos description of how to use List.Zip to easily create a list of lists for the old column names to the new columns names in the Table.ExpandTableColumn argument.

I just found your channel. You're producing great videos on PQ, and know what you're doing! That said, I always find videos easier to follow when the data used in the video is available - at least the final product if not both the starting point (like without queries) and end product. I just started to follow you on LinkedIn. Feel free to contact me if you have any questions.