Forum Discussion

ChubbChubb's avatar
ChubbChubb
Icon for Helper I rankHelper I
2 years ago

Attendance type over 10 Weeks

I need to work out on a rolling 10 week block how many particular attendance codes students have recieved during that 10 week cycle and if it is 10 or more flag them.   This is the code I use to wo...
Need Help
mh2587's avatar
mh2587
Icon for Super User rankSuper User
2 years ago
Rolling_10Week_Attendance_Flag = //Try this one
VAR StartDate = TODAY() - 63  // 63 days = 9 weeks
VAR EndDate = TODAY() // Current date
RETURN
    CALCULATE(
        COUNTROWS(ROLL_CALL_ATTENDANCE),
        FILTER(
            ROLL_CALL_ATTENDANCE,
            ROLL_CALL_ATTENDANCE[AttendanceDate] >= StartDate &&
            ROLL_CALL_ATTENDANCE[AttendanceDate] <= EndDate
        )
    ) >= 10
ChubbChubb's avatar
ChubbChubb
Icon for Helper I rankHelper I
2 years ago

thanks, I have to take into account school holidays, which is where the WEEK INDEX comes in as my date table contains all dates and I'm using the WEEK INDEX to show which are term dates.

  • mh2587's avatar
    mh2587
    Icon for Super User rankSuper User
    2 years ago

    Can you please share sample data ?