Calculate IRR according operationdate but display according endofquater

[Anonymous]

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)

If you need more information don't hesitate please . 

kinds