Forum Discussion

dm1904's avatar
dm1904
Helper I
7 years ago
Solved

Dataflow Merge and Aggregate

Hello, I have merge two tables together in a datafow. When I try to expand the resulting column I do not get the option to 'Aggregate' like I would do in desktop. I've tried adding the below as a cus...
Dataflow
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi dm1904 

    I can make it work on Power Query Web part.

    Please check if #"Merged queries 1" is the last step name in your scenario.

     

    Or you could take the following as a workaround:

    1. merge queries,

    2. expand the value from another table

    3. groupby the table as below

     

     

    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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi dm1904 

I can make it work on Power Query Web part.

Please check if #"Merged queries 1" is the last step name in your scenario.

 

Or you could take the following as a workaround:

1. merge queries,

2. expand the value from another table

3. groupby the table as below

 

 

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.