How to calculate a percent change between terms (i.e, fall to fall)

[lnschne2]

Hello, I'm new to Power BI, and I want to do a percent change of enrollment between terms.  I've done percent changes between months but not terms.

Here's how the data is set up 

First, I essentially need to sum all enrolled by term.  For instance, let's say there were 200 enrolled in Fall 2021, 300 enrolled in spring 2022 and 400 enrolled in fall 2022. 

I want to create a visual that shows the percent change between each term.  

Does anyone know how I could do that or write it in DAX?  

Thanks for your help! 

[amitchandak]

@lnschne2 , Create a separate table with semester with year, and other details. It should have one column like YYYYSS

Year Semester , Year, Semester  , Semester name

202101, 2021,1,spring

202102, 2021,2,fall

202201, 2022,1,spring

202202, 2022,2,fall

Join this back with your table on Year Semester

Create a rank on Year Semester, a new column

SemesterRank = RANKX(all('Date'),'Date'[Year Semester],,ASC,Dense)

This Semester= CALCULATE(Count('Table'[id]), FILTER(ALL('Date'),'Date'[SemesterRank ]=max('Date'[SemesterRank ])))
Last Semester= CALCULATE((Count('Table'[id]), FILTER(ALL('Date'),'Date'[SemesterRank ]=max('Date'[SemesterRank ])-1))

Power BI Custom Period Till Date (PTD)- https://youtu.be/rQ3Z_LtxwQM