Power Query - Adding spaces to CamelCase & number fields with List Accumulate

Подписаться 3,1 тыс.

50% 1

🚀 Unlock the Power of Data Transformation! | Power Query Tutorial 🛠️
Dive into the magic of Power Query with our latest tutorial! 🌟 Learn how to effortlessly add spaces to camelCase and number fields using the powerful List.Accumulate function. 📊 Whether you're a data enthusiast, analyst, or just curious about data manipulation, this video is your key to unlocking new possibilities. ✨
#PowerQuery #DataTransformation #ExcelTips #DataAnalysis #Tutorial #powerbi #excel
Link to File
github.com/jbotes/powerbiTuto...

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 16

@whizzohk 4 месяца назад

Thank you Sensei! Another great video on List.Accumulate. I have used this function in several real-world queries since you recently demonstrated its power and flexibility.

@kebincui 4 месяца назад

Your advanced tips on power query are always always excellent. Thanks James ❤👍

@basensei8699 2 месяца назад

My pleasure!

@ftmagicart 4 месяца назад

Great video. Your technique is amazing. Thank you

@basensei8699 4 месяца назад

awesome thank you!

@AnilKumar-vi8oe 4 месяца назад

Bang on, you are an artist man.... Learning in depth about power query from your videos....Keep bringing these awesome videos

@basensei8699 4 месяца назад

thanks man! this is glorious!

@eduardomunoz2764 4 месяца назад

wonderful, thank you very much. Greetings

@basensei8699 4 месяца назад

Thank you too!

@jerrydellasala7643 4 месяца назад

Great video, but wish you had posted the M Code or put it in a Note in the file. It took me an HOUR to finally see I had state & {" " & CurrentChar} instead of state & {" ", CurrentChar}! 🤪🤪 Would love to see a video on converting this to a function!

@kkaurkify 4 месяца назад

Thank you. Your teachings always open up a lot of new knowledge, how and what can be done. Also, I have a question. Does the file on github also have the code. There is no way I can see it.

@basensei8699 2 месяца назад

Yes it does

@roywilson9580 4 месяца назад

Thanks for the video.l I hated List.Accumulate the first few times I had to use it, kI couldn't get my head around the idea of iteration without some kind of for statement, my brain refused completely to process how the function could possibly keep count of hte number of iterations completed and after that sank in I had real problems seeing how the loop could end. I still find it makes my head ache writing the functions and debugging them is even worse!

@basensei8699 4 месяца назад

Hey Roy! i also took a while with it! hahah ait's so counter intuitive! not seeing a loop!

@roywilson9580 4 месяца назад

@@basensei8699 exactly!