Forum Discussion

dogburalHK82's avatar
dogburalHK82
Helper III
3 years ago
Solved

group by with condition

Hi,    in power query, when groping rows is there any way using Power M to pick column from each column as below   For Quanity ordered column, select maxium value For remaining, columns are sele...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi dogburalHK82 ,

     

    Here's my sample data. I also added a third row for a better demo. A column of Group IDs has also been added, and I think you have a similar column in your data for grouping.

    Here's my solution.

    1.You can group like this.

     

    2.Expand rows.

    3.Add a conditional column.

     

    4.Filter out "0".


     

    Best Regards,

    Stephen Tao

     

    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
3 years ago

Hi dogburalHK82 ,

 

Here's my sample data. I also added a third row for a better demo. A column of Group IDs has also been added, and I think you have a similar column in your data for grouping.

Here's my solution.

1.You can group like this.

 

2.Expand rows.

3.Add a conditional column.

 

4.Filter out "0".


 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.