How to reference prior date value when the value is a formula/measure?

[dancarr22]

Hello,

We have an Excel spreadsheet which we're hoping to migrate to Power BI.  The spreadsheet has a formula which references the prior date's value - but that prior date's value is a formula.  Please see Excel formula highlighted -- as well as the DAX I've come up with so far.  I can reference prior day value from a table fairly easily - but not sure how to do that when that value is a measure.  Greatly appreciate any help which can be offered.

TEST_PriorRecord = 
VAR EarliestRecordDate = CALCULATE(MIN('Dates (Filter)'[AsOfDate]),ALLSELECTED('Dates (Filter)'))
VAR CurrentRecordDate = CALCULATE(MAX('Dates (Filter)'[AsOfDate]))
VAR PriorDate = CALCULATE(MAX(Positions[AsOfDate (Filter)]),TOPN(1,FILTER(ALLSELECTED('Dates (Filter)'[AsOfDate]),'Dates (Filter)'[AsOfDate]<MAX('Dates (Filter)'[AsOfDate])),'Dates (Filter)'[AsOfDate],DESC))
VAR PriorDateValue = CALCULATE(SUM(AccountReturns[Account_ReportedReturn_QTD]),'Dates (Filter)'[AsOfDate]=PriorDate)
VAR IsEarliestRecord = IF(EarliestRecordDate = CurrentRecordDate, TRUE, FALSE)
RETURN IF(IsEarliestRecord, 1, PriorDateValue)

Thanks,

Dan