I had been waiting for a long time for Sir Kenji to upload a tutorial on Power Query, and finally, he did! 😁😁It's really great and easy to understand. 🥰Now, please make more videos on Power Query as well.
Hi, thanks for the video. I am desperate to retrieve data in power query from a microsoft list. I am using a Mac and when I get data from my SharePoint list, then I transform data. I have some columns where instead of the actual value it is mentioned "List". I searched everywhere and nothing works I can't believe I am the only one having this issue. All AI apps are suggesting to use the expand option but it is not available. Could you please help if you know how? Many thanks in advance. If you can't thats fine either :)
Hi Kenji. Is there any way to convert whole number to decimal form in power query? I tried to do that, it can be display as decimal in power query but as soon i load it, the data become whole number again. I've read it elsewhere that this is one of the limitation of powerquery.
🚀Get the FREE Data Analytics Guide from Hubspot:clickhubspot.com/ag9q
I don't have website for now,so how l can get the book because l really need it to start my journey as a data analyst.
Thank you Kenji. I need to understand power query more.
Thanks for your comment!
Bro your channel is priceless we appreciate you ♥
So Good. Thank You.
Thanks Kenji!
Very useful
this is so interesting, thanks!
Glad it was helpful!
Very helpful!! Thanks Kenji
Thank you for your helpful videos, Kenji!
Muchas gracias Kenji, you're an amazing Teacher
Thank you! 😃
Great Video Nice to know more about Power Query! Would Love to see more content about.. in the future as well .
Noted!
Thank you😊!
Awesone content as usual thanks Kenji
Amazing techniques. Thanks a lot for the video.
Thanks for the video. Any idea why you duplicate the query instead of referencing it, please ? Thanks
Would like to see power query update to the excel course of yours!
Amazing 😮
Very informative 😃
Glad it was helpful!
Hi Kenji. Would love a video on relationships, data model, and multiple power queries
the step of custom column for payment types can we use replace value insteed of it ? replace credit card with card and blank transfer into transfer ?
I had been waiting for a long time for Sir Kenji to upload a tutorial on Power Query, and finally, he did! 😁😁It's really great and easy to understand. 🥰Now, please make more videos on Power Query as well.
Thank you for watching :)
Great vidéo, where can i find all the functions like texte.contains, .....
Hi, thanks for the video. I am desperate to retrieve data in power query from a microsoft list. I am using a Mac and when I get data from my SharePoint list, then I transform data. I have some columns where instead of the actual value it is mentioned "List". I searched everywhere and nothing works I can't believe I am the only one having this issue. All AI apps are suggesting to use the expand option but it is not available. Could you please help if you know how? Many thanks in advance. If you can't thats fine either :)
Hi Kenji. Is there any way to convert whole number to decimal form in power query? I tried to do that, it can be display as decimal in power query but as soon i load it, the data become whole number again. I've read it elsewhere that this is one of the limitation of powerquery.
My formula for payment type keeps showing error after following the exact procedure. Any help Sir Kenji
Figured it out. Thanks
Plase upload the raw data so that we may practice it without any hudle
i did...and i mention that in the video (it's in the description and its free to download)
1st
yes!