Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Combing Tables

    Hi   I have a 500 + excel forms coming in via customers. I need to aggregate the results into one table.  Is this possible in Power Query.   An example would be         Many than...
Need Help
Tutorial Requests
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    First append queries

     

    Then group by columns

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi ,

 

Yes this is doable in Power BI.

 

Use datasource as (From Folder) and combine all the excel files into single one.

 

Thanks,

Nishanth.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous  thanks for your reply.

Are you able to show me an example with the tables I have provided as I have already tried this and Power BI just appends the tables together rather than aggregating the values

 

Many thanks

 

Jo.