Calculate metrics on day-by-day Azure DevOps board export

Hi PJVisscher89 ,
Thanks for lbendlin  reply.
Here some steps that I want to share, you can check them if they suitable for your requirement.
Create two calculated column:

Overdue = 
VAR _completedDate = 
CALCULATE(
    MAX('Table'[Date]),
    ALLEXCEPT(
        'Table',
        'Table'[Work item ID]
        )
)
VAR _targetDate = 
CALCULATE(
    MAX('Table'[Target Date]),
    ALLEXCEPT(
        'Table',
        'Table'[Work item ID]
    )
)
VAR _date = 
IF(
    _targetDate = BLANK(),
    DATE(2024,5,31),
    _targetDate
)
RETURN
IF(
    _completedDate > _date && _completedDate = 'Table'[Date].[Date],
    1,
    BLANK()
)

Overdue_Days = 
VAR _completedDate = 
CALCULATE(
    MAX('Table'[Date]),
    ALLEXCEPT(
        'Table',
        'Table'[Work item ID]
    )
)
VAR _targetDate = 
CALCULATE(
    MAX('Table'[Target Date]),
    ALLEXCEPT(
        'Table',
        'Table'[Work item ID]
    )
)
RETURN
IF(
    'Table'[Overdue] = 1,
    DATEDIFF(_targetDate,_completedDate,DAY),
    BLANK()
)

Using Aggregation on Columns on Views

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly