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!
can you post some sample data?
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?