I have a table that contains student attendance information with the following columns:
Student, Year, Term, Week, and Attended.
Attended is a 1 or a 0 showing whether or not the student attended class that week.
I need a measure that will tell me for a given week if a student has attended any class during the previous weeks of the term.
Any help would be greatly appreciated. New to PowerPivot, but enjoying the learning!