XIRR

[KAYKAY1811]

I have a table with Date, Fund Name, Amount (Negative or Positive). I would like to calculate XIRR for EACH Fund Name in the table. Please help

[KAYKAY1811]

Thanks. Can I make another request. The table has also a column named "Owner". This means "same" fund can be owned by different person. Of course each "Owner" fund will have a atleast ONE positive or negative number. XIRR formula works well. But, if I try to do sub-category based on "owner', it gives error. Please assist.

[Greg_Deckler · Accepted solution]

@KAYKAY1811 

Measure = XIRR('Table',[Amount]),[Date])

XIRR function (DAX) - DAX | Microsoft Docs

Create a table visual. Put Fund Name and Measure into the table.