Forum Discussion
New column with data from the most recent previous term
I have data about students' total credits earned and their GPA, but the data is as of the end of term. For the current term that the student is enrolled in, the two fields are blank. This is what th...
Hi,
PBI file attached.
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
Do you want the result to be a measure or a calculated column?
It should be a measure. If I want to see the GPA of all students enrolled in the current semester, I will see nothing but nulls, because the database only holds end of semester GPA. I want to fish the GPA from the students previous semester (whenever that might be) and put it in the record with the current semester. It doesn't need to be calculated, because it is all fixed historical data.
The red columns are what I want. You can see that they are from the two previous columns, one row down. Y.T (in blue) marks the year and month of the semester.
| Student ID | Name | Year | Term | Session | Y.T | Y/T | Credits for Term | Total Credits End of Term | GPA End of Term | Total Credits Start of Term | GPA Start of Term |
| 4 | Martha | 2023 | FALL | MAIN | 2023.9 | 2023/FALL | 11 | NULL | NULL | 75 | 3.96 |
| 4 | Martha | 2023 | SUMMER | SUM1 | 2023.51 | 2023/SUMMER | 6 | 75 | 3.96 | 69 | 4 |
| 4 | Martha | 2023 | SPRING | MAIN | 2023.1 | 2023/SPRING | 6 | 69 | 4 | 63 | 4 |
| 4 | Martha | 2022 | FALL | MAIN | 2022.9 | 2022/FALL | 6 | 63 | 4 | 57 | 4 |
| 4 | Martha | 2022 | SPRING | MAIN | 2022.1 | 2022/SPRING | 3 | 57 | 4 | 54 | 4 |
| 4 | Martha | 2021 | FALL | MAIN | 2021.9 | 2021/FALL | 3 | 54 | 4 | 51 | 4 |
| 4 | Martha | 2021 | SPRING | MAIN | 2021.1 | 2021/SPRING | 3 | 51 | 4 |
- Ashish_Mathur
Hi,
PBI file attached.
Hope this helps.