How did you learn about the underscore and all the transformations you can do with it? You do some really interesting code manipulations that I haven't seen anywhere else.
Playing with the data and reading books/articles about the topic! :) You can check our other videos! in them, we go into details about "each" syntax and some other, more complex M explanations.
Hi @Exceed Learning! I have tried this trick with my dataset but I got worst performance. I have a table with more than 50 millions rows and would like to pivot a column with 80 distinct values. Any suggestion?
This technique doesn't always yield the best result. in the case of such a big table, I would try to perform pivot operation as close to the source as possible (eq on the SQL side if the data resides in a database).
We currently provide solutions to problems we encounter working with our clients, therefore they might not be in the order of difficulty. If you are interested in a systematic approach to M language, we created a dedicated course about it at exceed.hr/en/courses/powerquery-fundaments/
@@ExceedLearning Thank you Sir. I am very curious about what it looks like to work on real data mash up task. Could you tailor your content to kind of mock up the real work you do with your clients. Your work is always exceptional Sir. Thanks for providing such high quality content. Thanks
@@qasimjan5258 Thank you! All our videos are based on real-life situations we encounter with our clients. The problem arises due to the complexity of the client's needs. Most of the time the solution contains many combinations of advanced M topics therefore those videos would be too long/complex. This way we reduce the complexity to isolated advanced topics, making it easier for viewers to consume content.
Great tip! One question. At this point ua-cam.com/video/0PA59DX-aBk/v-deo.html you go to expand the transposed table and the column names don't match the table columns. Can you adjust the "type table [column = type, column=type]" to tell PowerQuery the layout of the transposed table?
Loved it...thanks a lot for all wonderful videos...
Fantastic! It does cut the refresh time by a lot!
well done. Respect! appreciate your effort. i am learning many things from your channel. thanks for support us
Brilliant
Informative, thanks :)
How did you learn about the underscore and all the transformations you can do with it? You do some really interesting code manipulations that I haven't seen anywhere else.
Playing with the data and reading books/articles about the topic! :) You can check our other videos! in them, we go into details about "each" syntax and some other, more complex M explanations.
Hi @Exceed Learning! I have tried this trick with my dataset but I got worst performance. I have a table with more than 50 millions rows and would like to pivot a column with 80 distinct values. Any suggestion?
This technique doesn't always yield the best result. in the case of such a big table, I would try to perform pivot operation as close to the source as possible (eq on the SQL side if the data resides in a database).
Sir could you do power query M series from basics. Thanks
We currently provide solutions to problems we encounter working with our clients, therefore they might not be in the order of difficulty. If you are interested in a systematic approach to M language, we created a dedicated course about it at exceed.hr/en/courses/powerquery-fundaments/
@@ExceedLearning Thank you Sir. I am very curious about what it looks like to work on real data mash up task. Could you tailor your content to kind of mock up the real work you do with your clients. Your work is always exceptional Sir. Thanks for providing such high quality content. Thanks
@@qasimjan5258 Thank you! All our videos are based on real-life situations we encounter with our clients. The problem arises due to the complexity of the client's needs. Most of the time the solution contains many combinations of advanced M topics therefore those videos would be too long/complex. This way we reduce the complexity to isolated advanced topics, making it easier for viewers to consume content.
Great tip! One question. At this point ua-cam.com/video/0PA59DX-aBk/v-deo.html you go to expand the transposed table and the column names don't match the table columns. Can you adjust the "type table [column = type, column=type]" to tell PowerQuery the layout of the transposed table?