Forum Discussion
Expand and Aggregate in Power Query's Merge Queries
Hello,
What is the difference between Expand and Aggregate in Power Query's Merge Queries?
Hello Lora_0121 ,
Expand - Allows you to select specific columns from the related table and add them to your primary query as new columns.
Aggregate - Allows you to perform aggregate calculations (such as Sum, Average, Count, Min, Max, etc.) on columns from the related table and return a single summarized value for each match.If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
1 Reply
Hello Lora_0121 ,
Expand - Allows you to select specific columns from the related table and add them to your primary query as new columns.
Aggregate - Allows you to perform aggregate calculations (such as Sum, Average, Count, Min, Max, etc.) on columns from the related table and return a single summarized value for each match.If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S