Power Query M - Merge count of rows into another table

[J_Taylor]

As I am sure most issues with Power Query are, I know how to do it in Excel - but have no idea how to accomplish it in Power Query M. 

Just to be clear, I am using the Dataflows page from Dataverse (on the Power Apps page) to manipulate a Dataverse table. Using two tables, I am trying to create one new table.

The two tables are:

1. Students - a reference table with unique rows for each student.

2. Behaviour Issues - non-unique rows that list each time a student breaks the rules. I would liken it to monthly transactions at a register: some people come in more than once in a month and I am trying to count various common categories.

Students table:

Behaviour Issues:

I am aware of "Group By". However, this displays the data in its own table.

> Count of total of each student

>Count of each student and issue1

>Count of each student, issue1 and issue2 (I could have just done student and issue2, since issue2 is unique to issue1)

I have created a sheet showing the desired outcome (attached and below).

Not that it is much, but in Excel, this would be easy. For Total, I would just use CountIf looking for each time the student number occurred. The other columns would be CountIFS looking for the student number and each issue (referencing the headers). 

I don't know if "Group By" is part of the answer. I looked at "Merge Queries", but didn't get far enought with grouping to try. Hopefully, my explanation is clear. Any help to achieve my final table would be much appreciated.

[J_Taylor]

I never found an answer for this. Instead, I linked the tables directly with PowerBI and manipulated them through there. I used DAX measures, Power Query (merge) and custom columns to get what I needed.