Forum Discussion
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...
- Group by Activity ID
- Aggregate by
- All Rows
- Sum of Working Day Count
- Expand the "All Rows" aggregation
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
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
Thank you! It is resolved. You were extremely fast 😄
This forum is lucky to have someone like you.