Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Calculate IRR according operationdate but display according endofquater

Hello, I need your help please. I have difficulties in calculating the irr and to display in matrix.
I want to calculate the IRR according to the  operation date and display it in a matrix according end of quarter of operation date.
As below :

ndris_0-1684766591516.png


NB: when I select in my slicer 30 /06/2022 as reportingDate(endofquarter) I want to have the irr of the other end of past quarter of the same year;

I have 2 tables :

cashflow

operationDate

paid

proceed

nav

irrelement

reportingDate

date

reportingate Q(endofquarter)

 

There are no link between both tables.

 

measures in cashflows

IRRelement = 

CALCULATE(
- SUM(CashFlows[Paid]) + SUM(CashFlows[Proceed]) + CashFlows[NAV Q]
, FILTER(
CashFlows
, CashFlows[OperationDate] <= SELECTEDVALUE(ReportingDate[ReportingDate])
)
)
 
My IRR measeure is : 
 
IRRTEST =

VAR Summary =
SUMMARIZE ( 'CashFlows'
,'CashFlows'[OperationDate]
, "@Valeurs_cashflow"
, [IRRelement]
)

VAR FilterZeros =
FILTER ( Summary
, ABS([@Valeurs_cashflow]) > 5
&& [@Valeurs_cashflow] <> BLANK() && 'CashFlows'[OperationDate]<= [DateTest]
)
RETURN

IFERROR(
IF( OR( CashFlows[IRRelement]= BLANK(), CashFlows[IRRelement]<=0 )
,"N/A"
,XIRR (
FilterZeros
, [@Valeurs_cashflow]
,'CashFlows'[OperationDate])
)
,0)

 

 

If you need more information don't hesitate please . 

kinds

 

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.