Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to 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 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
Thanks so much @Greg_Deckler - that worked and sped up the process. Appreciate your help and quick response!
Thanks,
Dan
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |