Needed help on similar countifs function in Power Query.
In the attached spreadsheet, Table1 is my raw data containing student name, module, course name, course status and module completion %. Each module may contain more than 1 courses and module completion % is based on the number of completed courses within the module.
Table2 is the end result after going through Power Query GroupBy function on Name and Module Completion % column.
I wanted to do a countifs i.e. to count the number of modules completed by student within Power Query Add Column but was not able to do so.
Please help to point out where did I go wrong. Thanks.
Bookmarks