Forum Discussion
How to group rows?
Hi all,
This is a basic question... but for some reason i cant seem to group column values. I have tried both "summarize" in dax and "grouby" in query editor. How do i get (fact unit) summed by warehouse below? I need these to be aggregated so i can create a key (WH# + Part Number).
Argh! Group by in power query was not working because i had used 'count rows' rather than 'sum' on the balance column. Silly me. Thanks guys.
3 Replies
airwolf39 , are you trying to create a new table ?
refer
https://www.poweredsolutions.co/2019/07/30/grouping-rows-with-power-bi-power-query/
Summarize
https://www.sqlbi.com/articles/all-the-secrets-of-summarize/
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Argh! Group by in power query was not working because i had used 'count rows' rather than 'sum' on the balance column. Silly me. Thanks guys.
