cancel
Showing results for
Did you mean:

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

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 :

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)

kinds

0 REPLIES 0

Announcements

#### New forum boards available in Real-Time Intelligence.

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

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors