Forum Discussion

emredici's avatar
emredici
Regular Visitor
4 years ago
Solved

Replicate SUMIF in Power Query

Hi all,   I have the below table in Power BI Power query. I wanted to simplify the subject and paste the Excel copy of it instead.   The columns with blue titles are my available data. I want to...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    4 years ago
    • Group by Activity ID
    • Aggregate by
      • All Rows
      • Sum of Working Day Count
    • Expand the "All Rows" aggregation

     

  • ronrsnfld's avatar
    ronrsnfld
    4 years ago

    It does not appear that you are in the Query Editor (Power Query).

    Select `Home=>Transform`

    Then you will find the GroupBy option and, when the dialog box opens, select Advanced to be able to add multiple aggregations/operations

emredici's avatar
emredici
Regular Visitor
4 years ago

Hi ronrsnfld,

Thanks for the response.

I grouped the data by the Activity ID.

I aggregated all with sum of working day count. However, I couldn't see anything regarding "all rows"

The end result is this. I can't aggregate or select All Rows.

 

 

 

ronrsnfld's avatar
ronrsnfld
Super User
4 years ago

It does not appear that you are in the Query Editor (Power Query).

Select `Home=>Transform`

Then you will find the GroupBy option and, when the dialog box opens, select Advanced to be able to add multiple aggregations/operations

  • emredici's avatar
    emredici
    Regular Visitor
    4 years ago

    Thank you! It is resolved. You were extremely fast 😄
    This forum is lucky to have someone like you.