Education: Days enrolled for school year based on start date

[jglasgow]

I'm looking for a way to get a count of possible days for students in a school year, based on their enrollment date.   Some students begin at the beginning of the school year and others will start at a later date if they moved in later for example.   The trouble I'm having is the school year calendar and what days count as a possible day.  There are weekends, holidays, school breaks...that do not count.   

Any thoughts welcome!

[v-yuta-msft · Accepted solution]

@jglasgow ,

You need to build an extra holiday table to record the weekends and holidays. And then build a measure using dax like pattern below:

Days enrolled =
CALCULATE (
    COUNT ( Table[Date] ),
    FILTER (
        Table,
        Table[Date] > Start_Date
            && NOT ( Table[Date] IN VALUES ( Holiday[Date] ) )
    )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jglasgow · Accepted solution]

Thank you!  This is amazing .   It worked much better as a calculated column.

[v-yuta-msft · Accepted solution]

@jglasgow ,

You need to build an extra holiday table to record the weekends and holidays. And then build a measure using dax like pattern below:

Days enrolled =
CALCULATE (
    COUNT ( Table[Date] ),
    FILTER (
        Table,
        Table[Date] > Start_Date
            && NOT ( Table[Date] IN VALUES ( Holiday[Date] ) )
    )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.