XIRR with date table will not work properly

HI TorsteinZahl,

I think this should be related to your filter, one or more records have been filtered on your visual.
Then XIRR function will process the filtered records which include blank parts at 'value' and 'date' arguments. (these values should not be suitable for the function calculation)

Measure concatenate current 'Previous Quarter Value in Minus' and date field values:

Fixed measure formal with the condition and alternate results:

XIRR = 
VAR currDate =
    MAX ( fact_values[Date] )
VAR currPQ = [Previous Quarter Value in Minus]
RETURN
    IF (
        AND ( currPQ <> BLANK (), currDate <> BLANK () ),
        XIRR ( fact_values, [Previous Quarter Value in Minus], [Date] ,,BLANK())
    )

Regards,

Xiaoxin Sheng