Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
78
Views
Topic starter
Hi,
I have a table containing modules of three different qualifications. Please see attachment for example.
Essentially, i would like a column at the end as shown in attachment, the number of modules a student was competent in.
Hope you can help!
Thanks,
Anton
Posted : 24/08/2018 11:48 am
Hi Anton,
You can duplicate the query and use the Group tool (lesson 4.16) to count the pass results and then use Merge to bring the count back into the original query. See example file attached.
Mynda
Posted : 24/08/2018 10:59 pm
