DAX Rownumber() to act like SQL Row_Number() with Dynamic Date

Hello, everyone

First off, I'd like to admit that I'm not well versed in DAX.  So, there might be a simpler process.

I have a request to simulate the below SQL Server query using a dynamic date in Power BI.  Essentially, the most recent time that a "UniqueID" is used on or before a specific date.

WITH cte_test AS (
SELECT *, ROW_NUMBER() OVER (PARTITION BY UniqueID ORDER BY workDate desc) AS ROWID
FROM table1
WHERE workDate <= '2023-11-01'
)
SELECT max(workDate) AS workDate, status, count(UniqueID) AS countUniqueID, sum(AMOUNT_DUE) AS AMOUNT_DUE, sum(PRINCIPAL_AMOUNT) AS SUM_PRINCIPAL_AMOUNT, sum(INTEREST_AMOUNT) AS sum_INTEREST_AMOUNT
FROM cte_test
WHERE ROWID = 1
GROUP BY status;

I was able to get the data to come in as expected using the following DAX and a multiple select box.  The user wants the ability to change the date with the select box and update the data to use the new date as the "origin".

rwDateRank = ROWNUMBER(
    ALLSELECTED(impData[DWORK_OF_DATE],impData[LOAN_ID])
    ,ORDERBY(
        'impData'[DWORK_OF_DATE],DESC
    )
    , DEFAULT
    , PARTITIONBY('impData'[LOAN_ID])
)