Offset function combined with field parameter

This happens when you sort one column by another column (frequently done in Calendar tables).  The sort column needs to be part of the calculation.

Might need to use a SWITCH statement to handle the different scenarios.  It kinda defeats the purpose of the Field Parameters, but that's something you can recover from.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523