I have the following fliter to determine the number of students enrolled in the following periods, "Fall", "Spring" and "Summer".
VAR _enrollmentcount = CALCULATE(COUNTROWS(Enrollment),
All(Enrollment[Deposit Intent to Enroll Date/Time]),
Enrollment[Deposit Intent to Enroll Date/Time] >= _startdate
&& Enrollment[Deposit Intent to Enroll Date/Time] <= _enddate,
FILTER('Enrollment',CONTAINSSTRING('Enrollment'[Start Term and Year], _section)))
I would like to be able to updated he variable _ section with the appropriate period. I need to do this since the CONTAINSSTRING function requires quotes around the period name.
If I add the period name then the filter runs fine.
VAR _fallcount =If( _iterm = "Fall",
(CALCULATE(COUNTROWS(Enrollment),
All(Enrollment[Deposit Intent to Enroll Date/Time]),
Enrollment[Deposit Intent to Enroll Date/Time] >= _startdate
&& Enrollment[Deposit Intent to Enroll Date/Time] <= _enddate,
FILTER('Enrollment',CONTAINSSTRING('Enrollment'[Start Term and Year], "Fall"))))
)
My question is how to get quotes around the period name and how to successly implement the substution logic.
I appreciate everyones assistance.
