DAX Question RRS feed

  • 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!

    Monday, July 23, 2012 5:00 PM


All replies