Forum Discussion
difference btw 2 row for each feature
Hi,
I have the table 1 and I want to get to table 2 that shows difference on each grade per student and per subject.
Wht should I do? I tried group by but there is no function difference.
thank you so much
| subject | session | student | grade 1 | grade 2 |
| 1000 | 1 | 1 | 100 | 10 |
| 1000 | 2 | 1 | 50 | 0 |
| 1000 | 1 | 2 | 90 | 5 |
| 1000 | 2 | 2 | 90 | 5 |
| 2000 | 1 | 1 | 100 | 9 |
| 2000 | 2 | 1 | 100 | 1 |
| 2000 | 1 | 2 | 70 | 4 |
| 2000 | 2 | 2 | 90 | 5 |
| subject | student | dif grad1 | dif grad2 | |
| 1000 | 1 | 100-50 | 10-0 | |
| 1000 | 2 | 90-90 | 5 minus 5 | |
| 2000 | 1 | 100-100 | 9 minus 1 | |
| 2000 | 2 | 70-90 | 4 minus 1 |
Anonymous,
Try these measures:
Grade 1 Diff = VAR vSession1Row = FILTER ( Grade, Grade[session] = 1 ) VAR vSession2Row = FILTER ( Grade, Grade[session] = 2 ) VAR vSession1Grade = MAXX ( vSession1Row, Grade[grade 1] ) VAR vSession2Grade = MAXX ( vSession2Row, Grade[grade 1] ) VAR vResult = vSession1Grade - vSession2Grade RETURN vResult Grade 2 Diff = VAR vSession1Row = FILTER ( Grade, Grade[session] = 1 ) VAR vSession2Row = FILTER ( Grade, Grade[session] = 2 ) VAR vSession1Grade = MAXX ( vSession1Row, Grade[grade 2] ) VAR vSession2Grade = MAXX ( vSession2Row, Grade[grade 2] ) VAR vResult = vSession1Grade - vSession2Grade RETURN vResult
1 Reply
Anonymous,
Try these measures:
Grade 1 Diff = VAR vSession1Row = FILTER ( Grade, Grade[session] = 1 ) VAR vSession2Row = FILTER ( Grade, Grade[session] = 2 ) VAR vSession1Grade = MAXX ( vSession1Row, Grade[grade 1] ) VAR vSession2Grade = MAXX ( vSession2Row, Grade[grade 1] ) VAR vResult = vSession1Grade - vSession2Grade RETURN vResult Grade 2 Diff = VAR vSession1Row = FILTER ( Grade, Grade[session] = 1 ) VAR vSession2Row = FILTER ( Grade, Grade[session] = 2 ) VAR vSession1Grade = MAXX ( vSession1Row, Grade[grade 2] ) VAR vSession2Grade = MAXX ( vSession2Row, Grade[grade 2] ) VAR vResult = vSession1Grade - vSession2Grade RETURN vResult