Forum Discussion
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...
I tried to use Group By in Power Query Editor but the result tripled when i expand and selected some columns .
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.