Рет қаралды 1,702
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