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...
Try this:
Table=Summarize('MY_TABLE',
'MY_TABLE'[CLIENT],
'MY_TABLE'[DEPARTMENT],
"MAX(QTY)",MAX('MY_TABLE'[QTY])
)
Correct for some syntax, but you should get the idea.
regards