Power Query Trick ✅ Add Multiple Columns in 1 Go!

preview_player
Показать описание

#shorts #powerquery #powerbi #dataanalysis #datacleaning #datavisualization

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
  1. Goodly
  2. Power BI
  3. Power Query
  4. Excel
  5. DAX
  6. M Formulas
Рекомендации по теме
Power Query Trick 0:00:50

Power Query Trick ✅ Add Multiple Columns in 1 Go!

You WON'T BELIEVE 0:12:17

You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯

AWESOME Excel trick 0:08:43

AWESOME Excel trick to combine data from files with DIFFERENT headers

Power Query - 0:18:40

Power Query - Avoid 'Helper Queries' (+10 Cool Tricks)

Advanced Grouping Tricks 0:15:34

Advanced Grouping Tricks In Power Query

How to use 0:16:35

How to use Microsoft Power Query

5 Surprising Power 0:14:14

5 Surprising Power Query Tricks You Need to Know!

5 Tricks to 0:16:41

5 Tricks to Reduce Steps in Power Query

Get a Free 0:11:07

Get a Free Library as you Learn Excel Power Query Tricks (Custom data types, Hyperlink data type!)

10 awesome Power 0:15:44

10 awesome Power Query tricks you NEED to know! | Excel Off The Grid

Useful Power Query 0:00:38

Useful Power Query Trick🔥 || Quickly Go to Any Column

Insane Power Query 0:00:57

Insane Power Query Trick 🤯 | Refer to an Intermediate Step from another Query

Power Query Append 0:13:09

Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714.

EASY Trick to 0:11:47

EASY Trick to COMBINE Multiple Excel files into ONE with Power Query

Excel Magic Trick 0:00:46

Excel Magic Trick 1411: Power Query Add Prefix to Account Numbers in Column

2 Must-Know Power 0:12:09

2 Must-Know Power Query Tricks to Add Dynamic Blank Rows

I Bet You 0:12:28

I Bet You Don't Know All These Power Query Tricks

25 Amazing Power 0:32:03

25 Amazing Power Query Tips and Tricks

Reference an Intermediate 0:13:17

Reference an Intermediate Step from another Query | Power Query Tricks

EASILY Combine Multiple 0:08:48

EASILY Combine Multiple Excel Sheets Into One With This Trick

Powerful trick to 0:07:42

Powerful trick to combine all Excel files in a folder AUTOMATICALLY

Power Query Running 0:04:39

Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589

Advanced Group By 0:14:37

Advanced Group By Tricks in Power Query

AWESOME Excel trick 0:07:27

AWESOME Excel trick to combine data from multiple sheets

Комментарии
Автор

I always said.... Goodly is Bestly...

Thanks a lot bro 🤜

paravej
Автор

this is great and tidies up my applied steps massively. is it possible to set a data type using this method without the "changed type" applied step appearing; so setting as part of the record creation or setting as part of the expanding?

UKDevice
Автор

Amazing. I've used this straight away :D

leebecker
Автор

Way better than those stackoverflow trash methods with complex functions instead of using the native functionalities of PowerQuery (like always)

rta
Автор

Can you declare the data types in the same step?

leebecker
Автор

in my case its giving me back the FUnction instead of columns (

ИродаЮлдашева-ья
Автор

This doesn't work if the column names have spaces, and in that case putting the names in brackets, quotes or double quotes doesn't work either. Is there a way to make it work?

winfin
Автор

you're good but the problem is your greed

Hareesh-wq