cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
channah Frequent Visitor
Frequent Visitor

Data Arrangement issue

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 

 

3 REPLIES 3
Highlighted
Super User
Super User

Re: Data Arrangement issue

Hi there

if you can please send an example of your data and the expected output to assist us with your question?

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
channah Frequent Visitor
Frequent Visitor

Re: Data Arrangement issue

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

channah Frequent Visitor
Frequent Visitor

Re: Data Arrangement issue

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

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 151 members 1,597 guests
Please welcome our newest community members: