Forum Discussion
Solved
Power Query: COUNTIFS
Hello, I am struggling to achieve below CountIfs-Formula in PowerQuery. Any suggestions would be highly welcome! Thank you JDB79
Steps could be
- Group table by Number without aggregation (All Rows)
- add custom column to filter each of tables on "B"
- add another custom column to count number of rows in each such table
(above 3 steps could be combined in one in formula bar)
- in resulting table
keep only these columns
expand Count column and land result into the grid
Please check in attached file.
JDB79 , glad it helped