Forum Discussion
Calculating the difference between different rows with a common subject
Hi All, I am looking to calculate the difference between the grades , between the result sets for each aspect. So for 'Jim' I want to calculate the difference between his target and in autumn , ...
Hi BA_Pete I do not quite understand your explination, sorry I am not very experienced in this.
Would you be able to give me examples of what you have asked me to do.
I have attached an example of my data to help give you a better understanding.
So I would like to compare [Aspect] "KS4 FFT New Eng" [Result set] Year 11 FFT Reported Grade" [Grade] with [Aspect] "Teacher Assessment Eng New" [Result set] "Year 11 Autumn Term" [Grade].
I hope this makes sense and I look forward to your response.
Thank you for all your help so far.
| name | Result set | Aspect | Grade |
| Jim | Year 11 FFT Reported Grade | KS4 FFT New Eng | 2 |
| Jim | Year 11 FFT Reported Grade | KS4 FFT New Maths | 2 |
| Jim | Year 11 FFT Reported Grade | KS4 FFT New Maths | 3 |
| Jim | Year 11 FFT Reported Grade | KS4 FFT New Eng | 4 |
| Jim | Year 11 FFT Reported Grade | KS4 FFT New Eng | 3 |
| Jim | Year 11 FFT Reported Grade | KS4 FFT New Maths | 2 |
| Jim | Year 11 Autumn Term | Teacher Assessment Maths New | 2 |
| Jim | Year 11 Autumn Term | Teacher Assessment Eng New | 3 |
| Jim | Year 10 Autumn Term | Teacher Assessment Eng New | 3 |
| Jim | Year 10 Autumn Term | Teacher Assessment Maths New | 1 |
| Jim | Year 10 Spring Term | Teacher Assessment Maths New | 1 |
| Jim | Year 10 Spring Term | Teacher Assessment Eng New | 4 |
| Jim | Year 10 Summer Term | Teacher Assessment Maths New | 1 |
| Jim | Year 10 Summer Term | Teacher Assessment Eng New | 4 |
| Jim | Year 10 Interim Autumn Term | Teacher Assessment Maths New | 1 |
| Jim | Year 10 Interim Autumn Term | Teacher Assessment Eng New | 3 |
| Jeff | Year 11 FFT Reported Grade | KS4 FFT New Maths | 2 |
| Jeff | Year 11 FFT Reported Grade | KS4 FFT New Eng | 3 |
| Jeff | Year 10 FFT Reported Grade | KS4 FFT New Eng | 3 |
| Jeff | Year 10 FFT Reported Grade | KS4 FFT New Maths | 3 |
| Jeff | Year 10 Autumn Term | Teacher Assessment Eng New | 3 |
| Jeff | Year 10 Autumn Term | Teacher Assessment Maths New | 1 |
This is currently how i have my data in Power Bi which is not good :
(You can disregard the Attitude Aspect as Your previous solution will work for this)
Thank you again.