Expand and Aggregate in Power Query's Merge Queries

[Lora_0121]

Hello, 

What is the difference between Expand and Aggregate in Power Query's Merge Queries?

[dharmendars007 · Accepted solution]

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

LinkedIN