DAX Question

Question

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!

Answer 1

Hi iaaw100a

can you post some sample data?

---

Javier Guillen
http://javierguillen.wordpress.com/