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...