How to group rows?

[airwolf39]

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

[airwolf39 · Accepted solution]

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.

[Tahreem24]

@airwolf39 .

I am confused why are you facing any issue with Group by in Power Query.
YOu can try out using ALLEXCEPT:

Measure  = CALCULATE(SUM(Table[Fact Unit]),ALLEXCEPT(Table,Table[Warehouse]))

[amitchandak]

@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/