Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello,
What is the difference between Expand and Aggregate in Power Query's Merge Queries?
Solved! Go to 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
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
User | Count |
---|---|
66 | |
61 | |
47 | |
33 | |
32 |
User | Count |
---|---|
87 | |
72 | |
56 | |
49 | |
45 |