Calculated Column Doesn't work for current year only

I'm new to Power BI, and trying to learn quickly, but I'm scratching my head at this issue.  I also know this might not be the best way to accomplish what I'm trying to accomplish, so feel free to suggest alternatives.

I have a table of data rolled up by a few factors, include the Date, State, and a couple of other fields.  In each row there is a column called OpenAccounts representing the number of accounts that were in an Open Status on that date from that state, etc.

I have been tasked with creating a year over year comparison where the user can select the date to run the compairson for.  For this field, since the OpenAccounts is the number of accounts already open at a given point of time, I can't add up YTD.  I have to find the records that match the Date being selected.  In order to select that date, a request has been made to use a sliding date slicer, rather than a dropdown. I opted to use a Before Date Slicer.

In order to accomplish this, I created a measure to find the Max selected date:

ThisYearEndDate = MAXX(ALLSELECTED(QBR_DAILYTOTALS[TRANSACTIONDATEPST]), QBR_DAILYTOTALS[TRANSACTIONDATEPST])

This seems to work fine.  So then using this measure, I am trying to get the sum of values where the Month and Day of the TransactionDatePST field match the Month and Day of ThisYearEndDate.  After trying a bunch of different ways to do this, I settled on creating a calculated column as follows:

Open Accounts = IF(
    AND(
        MONTH(QBR_DAILYTOTALS[TRANSACTIONDATEPST]) = MONTH(QBR_DAILYTOTALS[ThisYearEndDate]),
        DAY(QBR_DAILYTOTALS[TRANSACTIONDATEPST]) = DAY(QBR_DAILYTOTALS[ThisYearEndDate])
    ),
    QBR_DAILYTOTALS[OPENACCOUNTS],
    0
)

Then I grab the SUM of that for all the open accounts on a given date.  This works for all Previous Years (2020, 2021) but always returns 0 for 2022.  I cannot for the life of me figure out why.

For Instance, if I have my Date Slicer to 4/1/2022, the numbers are correct for 2020 & 2021, but 2022 returns 0:

As you can see, doing a simple sum of OPENACCOUNTS for that day shows there are values, but the calculated field always sets it to 0.

Does anyone know what is going on here?  Or have a better solution for my issue?

Example Data: