PQB12: PowerQueryBasics:Merge Queries: Replace Sum-if with Power Query
Channel: AAA Excel’s Power
Date: 2020-04-26

Excel Data Analysis Series: PQB “Power Query Basics”
Data Transformation
PQB12: Merge Queries: Replace Sum if with PQ
Replace Sum If Using Merge
Use Aggregate instead of Expand
Use sum function to Aggregate numeric values

To download the excel file:
https://drive.google.com/open?id=14p8QjgMKzuKCiBs5ZY1fwiT9Eo1OTL4B

To watch the full playlist 
https://www.youtube.com/playlist?list=PL5NlUYOM2iOhZOJL_GM6zNd2k9-IEqmaV

To subscribe to the channel:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1

To follow on Facebook:
https://www.facebook.com/excelispower

To follow on LinkedIn:
https://www.linkedin.com/in/amratef