How to get YTD values using string (text) columns in matrix

I want to calculate my running total by period. What do I need to do to get it work when using text columns (PERIOD_SHORT) in my matrix?

PERIOD_SHORT is sorted by PERIOD_ID in my table, but it does not work with my DAX.

My Data Model (keys are TRXDATE <> Date):

My Measures:

Amount = SUMX(GL20000, GL20000[Amount])

Amount YTD Numeric = 
CALCULATE(
    [Amount],
    GL20000[PERIOD_ID] <= MAX(GL20000[PERIOD_ID])
)

Using PERIOD_ID as columns works because they can be ranked (year filter set to 2023):

Using PERIOD_SHORT does not work because it is a string(text)  (year filter set to 2023) :

My Data: