cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Education: Days enrolled for school year based on start date

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!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team

## Re: Education: Days enrolled for school year based on start date

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.

Frequent Visitor

## Re: Education: Days enrolled for school year based on start date

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

2 REPLIES 2
Community Support Team

## Re: Education: Days enrolled for school year based on start date

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.

Frequent Visitor

## Re: Education: Days enrolled for school year based on start date

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

Announcements

Kudos to you if you earned one of these! Check your inbox for a notification.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,791)