Forum Discussion
IRR error
Anonymous , I see need of one change, if this a measure then we need max in place of earlier
ROLLING IRR =
VAR minIndex =
CALCULATE ( MIN ( 'TEST - Working Capital'[Index] ), ALL ( 'TEST - Working Capital' ) )
RETURN
IF (
'TEST - Working Capital'[Index] > minIndex && NOT(ISBLANK('TEST - Working Capital'[Data])),
CALCULATE (
XIRR (
'TEST - Working Capital',
'TEST - Working Capital'[Cash flow amount],
'TEST - Working Capital'[Transaction Date]
),
FILTER (
allselected('TEST - Working Capital'),
MAx ( 'TEST - Working Capital'[Index] ) >= 'TEST - Working Capital'[Index]
)
)
)Trying to check in a file
Anonymous , Can share the error, which it is giving. check any hyperlink to get that
also, check
https://www.youtube.com/watch?v=N1WRSFuaFmE
https://community.powerbi.com/t5/Desktop/Create-a-measure-to-calculate-IRR-live/m-p/186302
amitchandak , he just gives me an error that he can't find a solution. (The XIRR function couldn't find a solution.)
Anonymous , I see need of one change, if this a measure then we need max in place of earlier
ROLLING IRR =
VAR minIndex =
CALCULATE ( MIN ( 'TEST - Working Capital'[Index] ), ALL ( 'TEST - Working Capital' ) )
RETURN
IF (
'TEST - Working Capital'[Index] > minIndex && NOT(ISBLANK('TEST - Working Capital'[Data])),
CALCULATE (
XIRR (
'TEST - Working Capital',
'TEST - Working Capital'[Cash flow amount],
'TEST - Working Capital'[Transaction Date]
),
FILTER (
allselected('TEST - Working Capital'),
MAx ( 'TEST - Working Capital'[Index] ) >= 'TEST - Working Capital'[Index]
)
)
)Trying to check in a file
amitchandak , thanks that was the bug. Looked at it too long to see the error.
I want to make this a 'Rolling IRR' based on different projects. So that he changes the IRR everyday day per project. How should I change the formula then?