Відео

Awesome, you have nailed it. Dealing with each and _ can be daunting and at time challenging and trick since the meaning changes according to the context. In fact it is the concept I have struggled a lot to get the hang of it in my recent Power Query Journey. Where we have two objects over which the iteration takes place we get a much better readable and comprehensive code by defining explicitly the anonymous function. Following the example of getting the maximum value of the text/string values I have worked it out as follows: defining two functions, the (row) => do_something_with_at_row_level and the (item) => do_something_inside_the_list_level! So within the let in expresion Source = ......... TextToList= Table.AddColumn(Source, "SalesList", (row) => Text.Split(row [Sales], ";")), NumericList = Table.AddColumn(TextToList, "SalesMax", (row) => List.Transform(row [SalesList], (item) => Number.From(item))), // combining step 1 & step 2 above in one single step MaxCompact= Table.AddColumn(Source, "SalesMax", (row) => List.Max(List.Transform(Text.Split(row [Sales], ";"), (item) => Number.From(item)))) Breaking and building the code with such temporary on the fly function in this way has helped me at larger to figure out why, how and when the each single parameter function navigates across diverse contexts.

This is really cool!

I know this video is 4 years old, but I could use some support. My refresh fail every time due to a "Request ID Error" I followed your instructions exactly, and everything works up until the point where we are to write the code to combine the old and new queries. Once writing the code and saving the query, I go to refresh and it fails. The refresh works perfectly fine prior to the CombineOldNew code being added to the advanced editor. Anyone have any input that could help?

how can this be done (colour formatting) on a card visual (not a matrix)? Tried to use the callout value colour fx but doesn't work

In this case at the begining of the video, the value 1 in the VBA code is not present in the result and value 10 is present too. Nevertheless great explantion, thank for sharing

anyone knows if it is working with the last version of power bi (july 2024)? I think is not the case. Thank you!!

What if I want to do other transformation on the nested tables before expanding?

excellent, very in depth explanation!!! tnx for this great video!

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