APQ10 | Budget Allocation using Power Query| Group By All Rows | Advanced Power Query
ฝัง
- เผยแพร่เมื่อ 17 พ.ค. 2024
- #excel #exceltutorial #powerquery #m_code
---------------------------------------------------------------------
Visit the website: www.aaa-power.net
---------------------------------------------------------------------
Chapters:
0:00 Intro
0:25 Budget Allocation example
1:03 Solution methodology
1:50 Send act_22 to Power Query
2:13 Remove unnecessary rows and columns and unpivot the table
2:53 Send bud_23 table to power query
3:22 Use group by (all rows) to calculate subtotals while keeping details
5:07 Calculate allocation %
5:30 Use merge queries to lookup budget numbers
6:18 Calculate allocated budget & remove unnecessary columns
7:23 Load result query to a pivot table
---------------------------------------------------------------------
To watch the full Playlist
• Advanced Power Query
---------------------------------------------------------------------
To watch PQB: Power Query Basics Series:
• PQB :Power Query Basics
---------------------------------------------------------------------
To watch PT: Pivot Tables Series:
• Excel Data Analysis: P...
---------------------------------------------------------------------
To download the working files:
drive.google.com/drive/folder...
---------------------------------------------------------------------
To subscribe:
/ @aaaexcelenglish
---------------------------------------------------------------------
To follow on Facebook:
/ excelispower
---------------------------------------------------------------------
To follow on LinkedIn:
/ amratef - วิทยาศาสตร์และเทคโนโลยี
Mashallah sir
Thank you 🙏
Nice speed and useful. Thanks.
Glad it was helpful!
Super thank you
Most welcome 🙏
Thank you so much
You're most welcome
Absolutely loved this tutorial. Straight to the point. Easy to follow, and very useful. You've earned yourself a subscriber 👍
Thank you so much, happy that you love it
Thanks for posting an interesting and informative video.
Most welcome 🙏
Thank you so much for this informative & awesome APQ series.
جمعة مباركة أ. عمرو، وبارك الله لك في علمك وعملك، وجعلها في ميزان حسناتك. 🤲
Thank you so much
جزاك الله خير .. شكرا جدا
Extremely useful tutorial. Thanks a lot 🙏
Most welcome 🙏
very informative lecture as usual. Thank you sir
So nice of you
Very nice tutorial.
Many many thanks
Thank you. You addressed my question from a few weeks ago.
Great 👍🏻 👏🏻🎉
My pleasure