XIRR Formula

[GAPER]

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

[amustafa]

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()
)