DateADD working Days

Hi RY2019 ,

The DATEADD function is a time intelligence function, there is a limitation about the function: "The result table includes only dates that exist in the dates column", it means when the result date isn't exist in the original data, it will return blank, more reference about this: DateAdd returns blank values - Microsoft Power BI Community

You can modify the formula like this:

Test Date =
'Database(Basic FIN)'[Finish date]
    + DATEDIFF (
        'Database(Basic FIN)'[Finish date],
        'Database(Basic FIN)'[Start date],
        DAY
    ) / 3

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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