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 Spring 2016 and 4,000 student for Spring 2015. How can I calculate Spring 2016 - Spring 2015 and show 1,000 difference.
Thank you.
2 Replies
Do you have a Date Table? To make time intelligence functions work you will need one.
see if this post help you => http://community.powerbi.com/t5/Desktop/Compare-MTD-with-previous-period/m-p/24656#U24656
also try this => http://community.powerbi.com/t5/Desktop/Time-Intelligence-YTD-SamePeriodLastYear-Odd-behavior/m-p/14683/highlight/true#M3923
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
