Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello:
I'm looking for some help with a few tables that I have to create. The first one is this:
Elementary Teacher by Grade Level Report | |||||||
Teacher names | Grade K | Grade 1 | Grade 2 | Grade 3 | Grade 4 | Grade 5 | Total |
Teacher 1 |
|
|
|
|
|
|
|
Teacher 2 |
|
|
|
|
|
|
|
Teacher 3 |
|
|
|
|
|
|
|
Total |
|
|
|
|
|
| Total |
The grade levels are not set up with their own data set or column name. They are created in an LMS section and inside that section they are listed in a name field. What I need to do is to look through that name field and find all references of the grades and total them to the teacher. This way we can get a quick snapshot of how many enrollments each teacher has for each grade level.
For instance, when I run this SQL query in our LMS: SELECT SectionIndex, Name FROM Sections WHERE [Status] = 'ACTIVE' AND TeacherIndex = 143
I'm assuming that I need some measure that will look at the string for First Grade, or Second Grade, etc... and count those Active instances to give me the total that I'm looking to populate in the table that I'm trying to create?
It will return this data to me that tells me that this teacher (whom we have given the index number of 143) is teaching these first grade classes:
I've brought this data in to my PowerBI Space to try and get this data compiled:
@RyanLMoran , Based on what I got
if your data is like the first screenshot. Comma-separated. Then you can split that in power query in rows.
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
You can also try text filter if that can help
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |