Neat 😊 I loved the pace of this video..Really helped me understand better the fourth argument, which I was not using much before..Brilliant 👍 The date table one was great example to understand..
Would it be possible to create videos using actual examples with real world application, not just theoretical possibility to combine/output this or that. You introduced good stuff, but I don't seem to be able to see how this would benefit usual corporate office type analytical work. Thanks.
Hi aatsw, It is very common that I received the same question about the application. Yes, I'll cover some complex examples. In the PQ challenge, the shared workbook contains a solution to the challenge with List.Generate. Remember, this function is very flexible, and understanding the concept is a must. When you want to repeatedly do one thing, this function is your friend. Whatever transformation I did in List.Accumulate can be achieved through List.Generate.
Great video! Could you do video on some reusable FX codes that you can use everywhere? Like, columns comparer, table comparers for duplicates or changes...or some error handling FX and so on... Think of it like calendar query that you can find everywhere and people are copy it in their reports.
There are a few keys you need master then M code becomes easy. The language grammar and its structures. The three main things to focus on M are table, list, and record. The best way to start M is to use the standard functions to generate the code and observe its behaviours.
Limited is fine. Try to understand the generated code. You can also watch some of my other videos like cell reference, level to M, etc. These videos can help you to understand some of the basics.
The answer is no. It is kind of like Excel. Understand the syntax can be understood as an understanding of vlookup or xlookup formula. It has the rules.
I m always impressed by your solutions thank you!
Thank you, Jerome.
Thank you very much KT 🙏🙏🙏
You're very welcome 🙂
Great 💯👍
Thank you, @rrrrassscccc80 for your kind compliment 😊
Neat 😊 I loved the pace of this video..Really helped me understand better the fourth argument, which I was not using much before..Brilliant 👍 The date table one was great example to understand..
Thank you, Sumanth. I'll keep this pace from now on. 🙂
Would it be possible to create videos using actual examples with real world application, not just theoretical possibility to combine/output this or that. You introduced good stuff, but I don't seem to be able to see how this would benefit usual corporate office type analytical work. Thanks.
Hi aatsw, It is very common that I received the same question about the application. Yes, I'll cover some complex examples. In the PQ challenge, the shared workbook contains a solution to the challenge with List.Generate. Remember, this function is very flexible, and understanding the concept is a must. When you want to repeatedly do one thing, this function is your friend. Whatever transformation I did in List.Accumulate can be achieved through List.Generate.
Great video! Could you do video on some reusable FX codes that you can use everywhere? Like, columns comparer, table comparers for duplicates or changes...or some error handling FX and so on...
Think of it like calendar query that you can find everywhere and people are copy it in their reports.
Hi mirror velll, it will be an extension to custom function. Noted. I need to find some examples.
I find M language extremely difficult to understand.
There are a few keys you need master then M code becomes easy. The language grammar and its structures. The three main things to focus on M are table, list, and record. The best way to start M is to use the standard functions to generate the code and observe its behaviours.
@@bsmart2gether408 Thank you Sir. I don't know where to start. I use the user interface in Power query but same is somehow limited.
Limited is fine. Try to understand the generated code. You can also watch some of my other videos like cell reference, level to M, etc. These videos can help you to understand some of the basics.
@@bsmart2gether408 .Thank you very much Sir. One question, to understand Power Query M language, one should have coding knowledge?
The answer is no. It is kind of like Excel. Understand the syntax can be understood as an understanding of vlookup or xlookup formula. It has the rules.