MAXX function running slow - how to make it run faster?

[dancarr22]

Hello,

I recently asked a measure question which was answered (very quickly and helpfully!) by @tamerj1 

Have a related question.  The following is running very slowly - seems to be the CALCULATE(MAXX... step

XIRR_BeginRMV_Date = VAR StartDate = [XIRR_BeginDate]
VAR isBefore = XIRR_Lookup[XIRR_BeginRMV_Date_IsBefore]
RETURN IF(isBefore="BEFORE", CALCULATE(MAXX(XIRR_Lookup,XIRR_Lookup[TransactionDate]),XIRR_Lookup[MappingName]="Reported Market Value", XIRR_Lookup[TransactionDate]<StartDate), BLANK())

Thanks again - really appreciate people taking time to look at and assist with these.

Thanks,

Dan

[Greg_Deckler · Accepted solution]

@dancarr22 Maybe:

XIRR_BeginRMV_Date = 
  VAR StartDate = [XIRR_BeginDate]
  VAR isBefore = XIRR_Lookup[XIRR_BeginRMV_Date_IsBefore]
  VAR table = FILTER('XIRR_Lookup', [MappingName] = "Reported Market Value", [TransactionDate] < StartDate)
  VAR result = IF(isBefore="BEFORE", MAXX(table, [TransactionDate]), BLANK())
RETURN
  result


or

XIRR_BeginRMV_Date = 
  VAR StartDate = [XIRR_BeginDate]
  VAR isBefore = XIRR_Lookup[XIRR_BeginRMV_Date_IsBefore]
  VAR table = SUMMARIZE(FILTER('XIRR_Lookup', [MappingName] = "Reported Market Value", [TransactionDate] < StartDate), [TransactionDate])
  VAR result = IF(isBefore="BEFORE", MAXX(table, [TransactionDate]), BLANK())
RETURN
  result

[dancarr22]

Thanks so much @Greg_Deckler - that worked and sped up the process.  Appreciate your help and quick response!
Thanks,

Dan