APQ10 | Budget Allocation using Power Query| Group By All Rows | Advanced Power Query

#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

[@ruzzputin]

Nice speed and useful. Thanks.

[@aaaexcelenglish]

Glad it was helpful!

[@SndfOmar]

Thank you so much for this informative & awesome APQ series.
جمعة مباركة أ. عمرو، وبارك الله لك في علمك وعملك، وجعلها في ميزان حسناتك. 🤲

[@aaaexcelenglish]

Thank you so much
جزاك الله خير .. شكرا جدا

[@M4D5K1L2]

Absolutely loved this tutorial. Straight to the point. Easy to follow, and very useful. You've earned yourself a subscriber 👍

[@aaaexcelenglish]

Thank you so much, happy that you love it

[@alexrosen8762]

Extremely useful tutorial. Thanks a lot 🙏

[@aaaexcelenglish]

Most welcome 🙏

[@sdr5593]

Thank you. You addressed my question from a few weeks ago.
Great 👍🏻 👏🏻🎉

[@aaaexcelenglish]

My pleasure

[@sr5726]

Thank you so much

[@aaaexcelenglish]

You're most welcome

[@roywilson9580]

Thanks for posting an interesting and informative video.

[@aaaexcelenglish]

Most welcome 🙏

[@zahoorsarbandi2982]

very informative lecture as usual. Thank you sir

[@aaaexcelenglish]

So nice of you

[@leosaghathan2895]

Super thank you

[@aaaexcelenglish]

Most welcome 🙏

[@khalidmajeed2886]

Mashallah sir

[@aaaexcelenglish]

Thank you 🙏

[@Bhavik_Khatri]

Very nice tutorial.

[@aaaexcelenglish]

Many many thanks