Forum Discussion
New Measure inside Matrix
I have created a matrix that calculates number of students for every semester. But my issue is creating a calculation that shows difference between semesters. For example, I have 5,000 students for S...
Assuming you do not have a datetable your data looks most likely like this
Year (or semester) - Name
1999 (Semester X) - John Malkovich
2001 (Semester 2) - Ricky Martin
...
One of the column must be your 'date column' somehow so you can have dates or semesters on your x-axis
The measures are quite trivial after that
No. of students YTD = CALCULATE(DISTINCTCOUNT((Name Column)) , DATESYTD(Date Column))
where YTD is short for Year To Date
No. of students LY = CALCULATE([No. of students YTD] , SAMEPERIODLASTYEAR(Date Column))
where LY is short for Last Year
Figure this one out... and you will figure out why datetables are really useful
google... ehm.. sorry BING is your friend