Forum Discussion

hettoritosi's avatar
hettoritosi
Frequent Visitor
6 years ago

Group BY One Column

Hi Guys, I need to do something like this using Power Bi:   select MAX(QTD) , CLIENT_NAME, DEPARTMENT from MY_TABLE GROUP BY CLIENT_NAME I tried to use GROUP BY function but did not return th...
Need Help
edhans's avatar
edhans
Community Champion
6 years ago

Power Query is more efficient at grouping, especially if the source is a relational database as it will fold the statement and make the server do the work. Just click on the Group By icon in the ribbon, select Advanced, and follow the prompts.

 

Consider posting your question not assuming readers can read SQL statements raw. I, for one, cannot. :smileyhappy:

hettoritosi's avatar
hettoritosi
Frequent Visitor
6 years ago

I tried to use Group By in Power Query Editor but the result tripled when i expand and selected some columns .

  • edhans's avatar
    edhans
    Community Champion
    6 years ago

    Could you share some data? GroupBy in Power Query doesn't just add extra rows. I use it all of the time. If you don't have a relationship right or aren't fully understanding how the underlying data exists then you will get unexpected results, but not incorrect results. That is true of Power Query, DAX, and even simple Excel formulas.