Forum Discussion
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...
amustafa
Solution Sage
Solution SageWell, 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()
)