How to Pivot Data in Power Query

Рет қаралды 6,307

Күн бұрын

📧 Subscribe to my Email Newsletter - goodly.co.in/s...
In this video, I'll explain how to pivot your data in Power Query, creating a cross-tabulated format for more effective data analysis.
• How to Fix Pivoting Er...
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/l...
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step-by-Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨‍🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
Download the file ⬇️ - goodly.co.in/w...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== 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'll find a ton of interesting videos that I have created :) Cheers!

Пікірлер: 12

@GoodlyChandeep 4 ай бұрын

📩Subscribe to my Email Newsletter - goodly.co.in/subscribe/ ⬇Download the file - goodly.co.in/wp-content/uploads/2024/05/How-to-Pivot-Data-in-Power-Query.xlsx Also, I have great courses on Power BI and Power Query. Don't forget to give it a shot 😉 - goodly.co.in/products.

@chrism9037 4 ай бұрын

Nice simple explanation, thanks Chandeep

@elphau 4 ай бұрын

thank you for spelling out the logic! i've always got confused whenever I try to pivot/unpivot my data. Could you explain "Unpivot Column" too?

@Rikodou99 2 ай бұрын

wonderful channel thanks!!

@Roberto-live 3 ай бұрын

Great video

@jagadevipatil7717 Ай бұрын

Nice one

@unnikrishnansanthosh 4 ай бұрын

really cool, thank you for sharing

@williamarthur4801 4 ай бұрын

One thing, after pivoting, getting back to the original by unpivoting?

@akashhanchatet-2842 4 ай бұрын

Delete the step 'pivot column' from the right panel that records(tracks) every step we perform in power query, And hence you'll get back to the original table. Goodly please correct me if I am wrong.

@qasimawan3569 4 ай бұрын

Just remove the applied step and it will go back to the original format

@williamarthur4801 4 ай бұрын

@@qasimawan3569 very good, I meant by unpivot 😊😊