Тёмный
No video :(

Power BI: Power Query Column Transform Must-Know Tips and Tricks🔍 

Pragmatic Works
Подписаться 231 тыс.
Просмотров 6 тыс.
50% 1

In this video, Matt showcases how to efficiently remove columns the correct way by using the choose columns feature. This allows you and collaborators to modify quickly what columns should be part of your dataset. After seeing this video, you will never use the standard remove columns icon ever again.
Matt also explains how you can quickly inspect a column in question by utilizing the Go-To Column feature. This comes in handy when your table in question has a copious amount of columns built-in. Finally, Matt explains how to efficiently document the thought process of your transform in the applied steps. Here he shows how to rename your applied steps as well and gives a description of what you are doing in the transform. This is again beneficial if you have to revisit an old report to modify the data model.
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2u...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
🔗Pragmatic Works Boot Camps: pragmaticworks...
🔗Pragmatic Works Hackathons: pragmaticworks...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
🔗Pragmatic Works Blog: blog.pragmaticw...

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RU-vid: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks #MattPeterson
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Compon...
~-~~-~~~-~~-~

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

 

17 авг 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 12   
@jawadahmadehssan6251
@jawadahmadehssan6251 2 года назад
Thank you for the information.
@kryptonets
@kryptonets 2 года назад
Hi, Don't know if someone is aware of that trick. Discovered it myself. If for some reasons you need to reorder columns and delete other, you can do it with just one step instead of two. 1)Select the columns you want in the order you want holding shift button 2)Use remove other columns 3)Profit,you have deleted Not used columns and reordered those you need🙂👍
@kennethstephani692
@kennethstephani692 2 года назад
Great video!
@PragmaticWorks
@PragmaticWorks 2 года назад
Thanks!
@Kevin-pt7rq
@Kevin-pt7rq 2 года назад
Very practical approach and definitely a best practice vs using Remove Columns. Thanks for this! Very useful.
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad it was helpful!
@sonetmollick4630
@sonetmollick4630 2 года назад
Nice and so informative.
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you think so!
@FRANKWHITE1996
@FRANKWHITE1996 2 года назад
Thanks for sharing
@PragmaticWorks
@PragmaticWorks 2 года назад
Thanks for watching!
@tubeitz
@tubeitz 2 года назад
Please share some advanced Power Query techniques cheers
@gonzo202
@gonzo202 2 года назад
This lesson was brought to you by the letter M.
Далее
Power Query: Add Column Header Spaces
13:58
Просмотров 3,4 тыс.
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
18:40
I Bet You Don't Know All These Power Query Tricks
12:28
Aggregating Data in the Power Query Editor
8:34
Просмотров 14 тыс.
Range Lookup in Power BI in the Power Query Editor
12:41
3 Ways to use Calculation Groups You Need to Know
20:00