Compare Applications

[Anonymous]

Hello. I am trying to compare applications for one Admit Term to another by Application Date. There are no specific enrollment periods as we have rolling admissions. I have an applications table. It contains Admit Term, Decision Type, Application Date. I connected the Application Date to my Calendar table. For marketing purposes, I need to show the number of applications for the previous Admit Term by the same month and day period from a Slicer but for the year that is in the Admit Term. For example:

Is this possible?

[v-chuncz-msft · Accepted solution]

@Anonymous,

Try using CALCULATE Function to change the context.

• https://community.powerbi.com/t5/Desktop/Year-on-year-for-previous-reporting-period/m-p/326661#M1457...
• https://www.sqlbi.com/articles/filter-arguments-in-calculate/