cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jglasgow Frequent Visitor
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
Community Support Team

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

@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.

 

 

View solution in original post

jglasgow Frequent Visitor
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.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

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

@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.

 

 

View solution in original post

jglasgow Frequent Visitor
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.

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

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

Microsoft Implementation for Communities Wins Award

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

Power Platform World Tour

Find out where you can attend!

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