Superb...just blew my mind...tx

Loved it...thanks a lot for all wonderful videos...

Awesome....great way of teaching... making complex things so easy ...

Tks for your easy explanation. Hope to see you with the next videos

Awesome, thanks you. (Extraordinario gracias).

@3:15 it states “Scholars lists or records but as an”… What is “Scholars”? I note the when you mention it at other points in comes up with alternatives such as ‘colors’. Can you clarify please?

Excellent tutorial, thank you

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

This is one of the best explanations of M Language i've seen so far ! All the best!

thankyou for this video is very helpful

Thanks. Had this popup for a user inexcel. I assume it must also have 2x data sources in pivot tables or something. Since both where internal I just told them to set public

very usefull. Thanks a lot

very insightful. thanks

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

excellent great job

Thanks

Good video, really helpful

Brillante ❤thank you

this is very useful, thx!

Nice explanation of each _ =)

I get a "Expression.Error: A cyclic reference was encountered during evaluation." on pbi desktop I am just loading a simple excel file from my pc.

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.

i would like to say big big thank you. i stuck in power query exactly i am facing like this problem. i search a lot in you tube finally your video solve my problem.

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

How can I merge 1excel file with another but only 2 colums of it?

Excellent videos Making complex concepts simple to understand.

nice tutorial.Thanks

Nice!

Great sutff, Thank you.

Excellent! I started with PQ before PBI and so DAX is less intutive for me. Thanks for the explanation.

Fantastic! It does cut the refresh time by a lot!

Very clearly explained! Thank you. I have the need for this sort of thing when working with Excel files downloaded from accounting systems. This is much more elegant than what I was doing.

Excellent tutorial❤

Super ❤

i was trying a lot since a couple of days to combine and i was getting errors, until i watched your video and my problem solved.. you helped me., thx. but if i add new column on one of the main tables, i can't see data comes into the querytable

My only complaint not enough videos! My proficiency in PQ has increased exponentially with every video of yours that I watch. Thank you!

So thats what _ means ! Thank yiu fir explaining. I ve been doing PQ for 1 year didn’t know.

Excelent content and very well explained. Thanks for your contributions!

Will it work in the CSV file format..?

Very Helpful

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

I think your PQ videos are amazing. I have learnt so much from you thanks

i have 5 excel workbooks with all the sheets named the same. what I want to do is combine the 5 excel files into one workbook with the sheets in each of the excel file file merged together with the same sheet name respectively. for example in excel file 1 there are sheet names sales and items and in excel file 2 there is also sheet names sales and items. what I want to do is combine the two excel files with each other so that excel file 1 sales and excel file 2 sales are merged together and excel file 1 and excel file 2 items are merged together. Is there a way for this? And I want the excel file to be updated on a regular basis maybe weekly once or twice if there are any changes into the 5 excel files I do not want to put them all in one destination file. I want to keep the 5 excel files as it is but combine them as one excel file where it gets updated frequently if there are any changes into the 5 excel workbooks

Thankyou, very useful and very well presented. One of the best Power Query videos i have seen

Thanks a lot for sharing this with us!

Liked, shared, and followed along with my own workbooks. Thank you for the video.

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!

What`s folding?

This playlist of three videos helped me a lot.

Awesome