How to Pivot Data in Power Query
HTML-код
- Опубликовано: 30 сен 2024
- 📧 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!
📩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.
Nice simple explanation, thanks Chandeep
wonderful channel thanks!!
Nice one
Great video
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?
really cool, thank you for sharing
One thing, after pivoting, getting back to the original by unpivoting?
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.
Just remove the applied step and it will go back to the original format
@@qasimawan3569 very good, I meant by unpivot 😊😊