Forum Discussion

jcrandal's avatar
jcrandal
Regular Visitor
5 years ago

XIRR Calculations matrix visual

Hello,   I am having trouble with my XIRR measure working in a matrix visual. When I apply the measure to a card, and filter based on two sets of prices, everything works fine for the card. When I ...
Need Help
jcrandal's avatar
jcrandal
Regular Visitor
5 years ago
IRR = if(IFERROR(XIRR('Volumes (Oil and Gas)',[DT Net Cash Flow],'Volumes (Oil and Gas)'[Date].[Date]),0)<0,0,IFERROR(XIRR('Volumes (Oil and Gas)',[DT Net Cash Flow],'Volumes (Oil and Gas)'[Date].[Date]),0))