topic Re: MAXX function running slow - how to make it run faster? in DAX Commands and Tips

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

dancarr22 — Mon, 03 Apr 2023 21:02:02 GMT

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

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

Greg_Deckler — Mon, 03 Apr 2023 22:03:53 GMT

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

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

dancarr22 — Mon, 03 Apr 2023 23:26:41 GMT

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

Dan