Forum Discussion
Filters withing Variables
Im trying to create a 1 Year IRR function. To do this I need an initial value. Below is my attempts at starting to calculate this value. I want to sum together all the values in the Multiple column u...
Try this out but I don't have enough info to be sure that it'll do what you're after. You'd have to be more precise and post some screenshots of the model. The explanation of the calculation you've given is not razor-sharp.
[Initial Value] =
VAR __boundaryDate = [1 Year (Adjusted)]
VAR __maxCalendarPmeDate = [Max Calendar PME Date]
VAR CallSumofMultiple =
CALCULATE (
SUM ( Transactions[Multiple] ),
-- Depending on what you want, you can try to remove
-- KEEPFILTERS leaving only the statement it surrounds
-- and see what you get. You should read about KEEPFILTERS
-- if you haven't yet and how it changes the way
-- filters from different contexts interact with each
-- other.
KEEPFILTERS( Transactions[TransactionType] = "Call" ),
'Calendar'[Date] <= __boundaryDate,
ALL( 'Calendar' )
)
VAR CallMultipleValue =
IF (
__boundaryDate = __maxCalendarPmeDate,
CallSumofMultiple
)
RETURN
CallMultipleValue