cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Helper I

## 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

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors