Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

XIRR Formula

I know that the XIRR formula is using the date column 

 

XIRR(<table>, <values>, <dates>, [, <guess>[, <alternateResult>]])

 

if there a way i can reorder the dates in to a order I want? Because for my XIRR formula, it will not generate results if i the date order is ascending. 

 

Thanks

Need Help

1 Reply

  • amustafa's avatar
    amustafa
    Solution Sage
    2 years ago

    Well, one way to do this is to create a custom sort order column in your table and then use it in XIRR. Here's a sample in how to create a DAX calculated column.

     

    CustomSortOrder =
    SWITCH([Date],
    DATE(2024,1,1), 1,
    DATE(2024,1,2), 2,
    DATE(2024,1,3), 3,
    // Add more dates and corresponding numbers as needed
    BLANK()
    )