Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 the expected result
Hi @hettoritosi ,
Please give me some sample data. Then maybe I could give you one workaround.
Best Regards
Icey
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
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.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |