Top 5 easy to implement Power Query tricks

  Рет қаралды 1,702

Exceed Learning

Exceed Learning

Күн бұрын

This time we share 5 easy tricks that can improve your performance in Power Query! In case you know another cool shortcut, feel free to post it in the comments!
To learn more about Power Query, check out our Power Query fundamentals course!
exceed.hr/en/academy/powerque...
Timestamps
0:00 Intro
0:34 Trick 1: Filtering
2:06 Trick 2: Opening new Excel file
3:28 Trick 3: Merging with multiple columns (holding CTRL key)
4:11 Trick 4: Making merge case insensitive
5:05 Trick 5: Adding a custom column
#powerquery #powerbi #etltools #data #dataanalysis

Пікірлер: 5
@nettingpros
@nettingpros Жыл бұрын
Good stuff! Tricks are super handy.
@malchicken
@malchicken 3 жыл бұрын
Thank you :) I appreciate the any video that helps “group” similar ideas together around a common theme or task. That helps me organize in my own brain when I encounter an issue, I’m like “oh I’ve seen a video that shows me the ‘combo moves’ that pair well together to help address this”. Much appreciated :)
@malchicken
@malchicken 3 жыл бұрын
Additionally, any videos showing multiple paths to the same result are helpful, I find, to understand when one technique may be preferred over another. As an example, Curbal recently posted a video taking the previous row using merge, I’ve seen “ExcelIsFun”(?) do the same thing by using the index as an offset reference to the previous row. The second technique seems less memory intensive, but I appreciate seeing both paths to the same outcome. It helps me form a “web” of possible solutions. Videos comparing multiple paths to the same place are helpful; please consider. Thank you :) Curbal video: kzfaq.info/get/bejne/rb6RmMyZ1bWVZ2w.html
@FRANKWHITE1996
@FRANKWHITE1996 2 жыл бұрын
Just subscribed 👍
@Unbox747
@Unbox747 2 жыл бұрын
Neat
How to process multiple folders with a single Power Query script
13:17
Exceed Learning
Рет қаралды 13 М.
Rename first N columns in Power Query
13:38
Exceed Learning
Рет қаралды 3,3 М.
ОСКАР ИСПОРТИЛ ДЖОНИ ЖИЗНЬ 😢 @lenta_com
01:01
Nutella bro sis family Challenge 😋
00:31
Mr. Clabik
Рет қаралды 11 МЛН
The day of the sea 🌊 🤣❤️ #demariki
00:22
Demariki
Рет қаралды 106 МЛН
Combine multiple Excel files using custom M functions
12:58
Exceed Learning
Рет қаралды 3,4 М.
Advanced Pivot Table Tricks ONLY Experts Know
9:39
Kenji Explains
Рет қаралды 469 М.
Dynamic Coalesce in Power Query ( Record.SelectFields() )
9:42
Exceed Learning
Рет қаралды 2,9 М.
Optimizing Pivot operation in Power Query
6:53
Exceed Learning
Рет қаралды 3,6 М.
Stop Doing Manual Reconciliations in Excel: Use Power Query
16:18
Excel University
Рет қаралды 69 М.
Learn Power Query & Automate Boring Data Tasks in 15 Minutes!
18:45
ОСКАР ИСПОРТИЛ ДЖОНИ ЖИЗНЬ 😢 @lenta_com
01:01