Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |