You’re offline. This is a read only version of the page.
Announcements
206
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.
Share
Report
All responses (
Answers (
