I am in the brainstorming stage for calculating the distinct count of students who are attending in a specified year/term, and of those same students, which did not attend the previous year/term.
The dataset does contain multiple records per student ID, one record for each term they have attended. I can attach the dataset if needed (with sensitive data replaced/removed).
We do have PowerPivot Version: 11.0.3000.0 in Excel 2010, Version 14.0.7143.5000 (32-bit). I am new to using PowerPivot (but am loving it).
I believe it maybe might be best to steer clear of array formulas if it can be avoided due to the performance, as we will be displaying these results across multiple years in a report summary sheet, however, I am open to any efficient and effective approach!
Any ideas will be much appreciated!
Thanks in advance,