I have a calendar table with year week column having values like Y24 W1,… This column is sorted by YearWeekNumber (202401,…).

In DAX, for example, if I want to show sum of sales amt for all weeks on or after 2024 W5, then if I write:

CALCULATE(SUM(SALES['SALESAMT']),YEARWEEK>="Y24 W5")

Does the above YEARWEEK adhere to the sortby when evaluating the >= ?