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.
I have data from several different data tables that have a little bit of data from each that I am using - one of the issues that I have though is that students, who have 8 different classes, I want to show on the same row with the student name and demographics etc vs the student showing up as 8 different rows with the data for each class showing up as its own row 😞
any suggestions thanks
Data that I have looks like this
Student name | school name | grade | Course | Attendance | lates |
Sally | Maple | 10 | Eng | 1 | 10 |
Sally | Maple | 10 | Science | 2 | 1 |
Sally | Maple | 10 | Math | 3 | 5 |
Sally | Maple | 10 | Pe | 4 | 4 |
I would like to see it like this
Student name | school name | grade | Course | course | course | course | Attendance totals | Lates total |
Sally | Maple | 10 | Eng | science | math | pe | 10 | 20 |
Data that I have looks like this
Student name | school name | grade | Course | Attendance | lates |
Sally | Maple | 10 | Eng | 1 | 10 |
Sally | Maple | 10 | Science | 2 | 1 |
Sally | Maple | 10 | Math | 3 | 5 |
Sally | Maple | 10 | Pe | 4 | 4 |
I would like to see it like this
Student name | school name | grade | Course | course | course | course | Attendance totals | Lates total |
Sally | Maple | 10 | Eng | science | math | pe | 10 | 20 |
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.