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...
Wouldn't you need to put GROUP BY Client Name, Department.
I don't think SQL likes when you have non aggregated columns not in a group by.