Power Query Formula Help

Подписаться 89 тыс.

Просмотров 13 тыс.

50% 1

Need help with your Power Query "M" language functions and formulas?
🔽 Expand to see more info 🔽
Here’s 3 ways to get started:
00:37 Tip on adding Blank Query to Quick Access Toolbar
01:04 Create a small table using {1..10}
01:29 The Custom Column URL link
02:27 The Formula Bar method
03:26 #shared
Follow me on LinkedIn
/ wynhopkins
Twitter
/ wynhopkins
Access Analytic Training
accessanalytic.com.au/training

Хобби

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

3 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@MM-nr8nf 3 года назад

You made my day...it's saving lot of googling time.

@AccessAnalytic 3 года назад

Loving the "M" M M

@Gorman-84 3 месяца назад

That last one is so cool. Thank you.

@mnowako 2 года назад

Excellent, thank you!

@gef24 Год назад

About the intellisense bug, I was even more angry than you when it happens. But I found that the bug seems caused by the dot. Typing the beginning or middle part of the function name without the dot works for me.

@AccessAnalytic Год назад

Yep, absolutely.. never type the dot 😀 ru-vid.comhRG896QO4wI?feature=share

@KagnaraRa 10 месяцев назад

This is really life saving. Thank you do much for sharing.

@AccessAnalytic 9 месяцев назад

You’re welcome, I appreciate you taking the time to let me know you found it useful

@utubeAgape 3 года назад

Wow - this is great - thankful!

@AccessAnalytic 3 года назад

Thanks for letting me know Irene

@malejandrahorvath 3 года назад

Awesome! Thank you!!!

@AccessAnalytic 3 года назад

Glad you liked it Alejandra

@YouExcelTutorials 3 года назад

Another awesome video! Thanks for sharing Wyn👍

@AccessAnalytic 3 года назад

Glad you liked it 😀

@MaryGKhani 3 года назад

That was great, thanks 👌🏻

@AccessAnalytic 3 года назад

Thankyou for letting me know you liked it Mary

@JonathanExcels 3 года назад

Thank you. I just need to remember to do it inside of PQ

@pranipradani9853 2 года назад

Thank you. This is really helping me 🙏

@AccessAnalytic 2 года назад

Great, thanks for letting me know Prani

@smartshan4u 3 года назад

Thanks for sharing

@AccessAnalytic 3 года назад

No worries Shantanu

@DavidMend18 Год назад

Wow, didn't know about this before now. Thanks

@AccessAnalytic Год назад

You're welcome David

@sukoi2113 3 года назад

It was indeed a great hack. Thanks a lot.

@AccessAnalytic 3 года назад

Thank you Rajneesh

@didijaba 3 года назад

Good one, thanks

@AccessAnalytic 3 года назад

No worries Tomislav

@IvanCortinas_ES 3 года назад

Excellent. The method with #shared is the one I usually use. Thank you for this tutorial.

@AccessAnalytic 3 года назад

Thank you Iván, yes #shared is a hidden gem

@excelworx8712 3 года назад

super video

@AccessAnalytic 3 года назад

Thank you very much

@khurramliaquat469 2 года назад

Hi, I have a question. When you type a formula in the formula bar, a list of formulas opens. Is this an option that needs to be checked or is there another way to do it?

@AccessAnalytic 2 года назад

Hi, it's there if you have Office 365 (and I think 2021 / 2019 )