New Measure inside Matrix

[burak]

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.

[Anonymous]

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

[Sean]

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/14...