Showing incorrect value while calculating XIRR

[Anonymous]

Hello,

Want to calculate daily inception till date xirr , however have cashflow in one column and every EOD value in other Column

wrote following dax but it not adding MFilter2 values in union 

XIRRITD% =

//Var Qdate = LOOKUPVALUE('date'[FirstDayofMonth],'date'[Date],PREVIOUSDAY(PPF[FROMDATE])+1)

Var Qdate = [NAVMINDATE]+21

//Var QdateFinal = if((Qdate)<=[NAVMINDATE],[NAVMINDATE],Qdate)

Var QdateFinal = [NAVMINDATE]+21

Var BODValue = LOOKUPVALUE(PPF[BODCASHFLOW],PPF[CLIENTID],VALUES(PPF[CLIENTID]),PPF[TODATE],QdateFinal)

Var BODFinalValue = if(ISBLANK(BODValue),0,BODValue)

//Var tab1 = FILTER(PPF,PPF[CLIENTID]=VALUES(PPF[CLIENTID])&&PPF[TODATE]=QdateFinal)

var MFilter1 = ROW("Date",Qdate,"Cashflow",BODFinalValue)

Var tab = FILTER(PPF,PPF[CLIENTID]=VALUES(PPF[CLIENTID])&&PPF[TODATE].[Date]>=QdateFinal+1&&PPF[TODATE].[Date]<=PREVIOUSDAY(PPF[TODATE])&&PPF[NetCashflow]<>0)

var MFilter2 = SELECTCOLUMNS(PPF,"Date",PPF[TODATE],"Cashflow",PPF[NetCashflow])

var m = ADDCOLUMNS(SUMMARIZE(tab,PPF[TODATE].[Date]),"Cashflow",SUM(PPF[NetCashflow]))

Var EODValue = LOOKUPVALUE(PPF[EODAUM],PPF[CLIENTID],VALUES(PPF[CLIENTID]),PPF[TODATE],PREVIOUSDAY(PPF[TODATE])+1)

Var EODFinalValue = if(ISBLANK(EODValue),0,EODValue)

var MFilter3 = ROW("Date",PREVIOUSDAY(PPF[TODATE])+1,"Cashflow",EODFinalValue)

//var MFilter1 = ROW("Date",TODAY(),"Cashflow",10000)

//Var a1 = Union(MFilter1,MFilter2,MFilter3)

var FinalData = UNION(

MFilter1,

MFilter2,

MFilter3

)

Var Output = IFERROR(XIRR(FinalData,[Cashflow],[Date]),0)

Return

Output

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490