that's great. i've watched many m code videos and taken many courses and nowhere have i seen that there are two different syntax types that produce the same result. so, this is very helpful to someone wanting to learn m code. keep up the good work in producing videos that are concise and useful. please consider offering a full course on m code or PQ. thank you.
Great playlist, and appreciate the list of types available in the blog. I've been aware that ", type..." could be added to many steps, however after trying it for a while I discovered that if a step was modified and even sometimes the any part of the query was modified, the ", type..." I had added was automatically removed, so I simply stopped doing that. I didn't make any connection with what functions specifically did that, and perhaps when using a Custom Column that won't happen. Have you encountered the disappearing ", type...", and are you sure that wouldn't happen with a custom column?
Hi I’m facing problems when I’m I connecting from snowflake table in 255 column names ( like date , text ,number ) in to power query , there is two steps auto generating 2 steps, source and Navigation, the next “changed type” is not generating . My question: how to write a custom column to change all columns data type at one time based on their column type . Yes if I have 10 columns I can change manually. But now I have 255 columns. Requesting you please help me it will very helpful to me I’m following your videos it is very helpful. In advance many thanks Best Regards Venkat
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
To learn more about functions and syntax make sure to check out: powerquery.how/
Enjoy!
that's great. i've watched many m code videos and taken many courses and nowhere have i seen that there are two different syntax types that produce the same result. so, this is very helpful to someone wanting to learn m code. keep up the good work in producing videos that are concise and useful. please consider offering a full course on m code or PQ. thank you.
It's not very well documented, but good to be aware of. Thanks for watching!
Great playlist, and appreciate the list of types available in the blog. I've been aware that ", type..." could be added to many steps, however after trying it for a while I discovered that if a step was modified and even sometimes the any part of the query was modified, the ", type..." I had added was automatically removed, so I simply stopped doing that. I didn't make any connection with what functions specifically did that, and perhaps when using a Custom Column that won't happen. Have you encountered the disappearing ", type...", and are you sure that wouldn't happen with a custom column?
Great tip! But the currency type is missing. Can you only add it with gui?
Hi I’m facing problems when I’m I connecting from snowflake table in 255 column names ( like date , text ,number ) in to power query , there is two steps auto generating 2 steps, source and Navigation, the next “changed type” is not generating .
My question: how to write a custom column to change all columns data type at one time based on their column type .
Yes if I have 10 columns I can change manually. But now I have 255 columns.
Requesting you please help me it will very helpful to me
I’m following your videos it is very helpful.
In advance many thanks
Best Regards
Venkat
Are you related to the Gorilla Glue Girl? You should teach her Power BI at least.
Haha, that would have been great Phoenixspin. I'm not related in any way. But if she's interested I'm happy to teach her!