XIRR error as starting number is zero

Hi Anonymous 

I have applied the stepps correctly for generating IRR but not sure where i am missing the steps in the calculations. I am strugling a lot for finding the right solution. Provided all the data below with calcations, tables. Thanks in advance

In Excel, it's getting IRR for fund A is 3.11%, B is 46% and total IRR is 3.35%

Backend calculations

1) Running Tota =

CALCULATE(SUM(Table1[Daily NAV]),

FILTER(ALL(Table1[Date]),Table1[Date]<=MAX(Table1[Date])))

2) Ending NAV =

var _maxdate = CALCULATE(MAX(Table1[Date]),ALLSELECTED(Table1[Date]))

RETURN

SWITCH(TRUE(),MAX(Table1[Date])=_maxdate,[Running Tota],MAX(Table1[Date])<_maxdate,0,BLANK())

3) NAV+Cashflow = SUM(Table1[Capital call])-SUM(Table1[Distribution])-[Ending NAV]

4) IRR =

var nonzero = IF([NAV+Cashflow]=0,1,[NAV+Cashflow])

RETURN

XIRR(Table1,nonzero,Table1[Date],,0.00001)

DateFundCommitmentCapital callDistributionDaily NAV