Jul 10 2021 02:48 AM
Hello,
I am struggling to achieve below CountIfs-Formula in PowerQuery.
Any suggestions would be highly welcome!
Thank you
JDB79
Jul 10 2021 04:19 AM
I'm certainly not the most suitable to submit a suggestion to you, but I'll give myself a try :).
Here is a small example .
would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Jul 10 2021 04:39 AM
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.
Jul 10 2021 05:03 AM
SolutionJul 10 2021 05:06 AM
Jul 10 2021 05:03 AM
SolutionHello,
Many thanks. Yes, this will work for me.
Thank you.
JDB79