Do Calculation within SUMMARIZE

Syndicate_Admin , You have create measures

Create a separate table with distinct SEASON

Period = distinct(Sheet1[SEASON])

Join back with SEASON

In period table add a Rank column

Period Rank = RANKX(all(Period),Period[SEASON],,ASC,Dense)

Now Create a new measure

This Period = CALCULATE(sum('Sheet1'[COMMERCIAL UNITS]), FILTER(ALL(Period),Period[Period Rank]=max(Period[Period Rank])))

Last Period = CALCULATE(sum('Sheet1'[COMMERCIAL UNITS]), FILTER(ALL(Period),Period[Period Rank]=max(Period[Period Rank])-1))

Same as week on week

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

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