Column with Duplicate Dates

Hi gmasta1129, 

You can do this with a DAX expression that only returns the Due Date on the row with the latest Value Date.

Calculated column:

Due Date Final =
VAR MaxValueDate =
    CALCULATE (
        MAX ( 'YourTable'[Value Date] ),
        ALLEXCEPT ( 'YourTable',
            'YourTable'[Report Date],
            'YourTable'[Facility Code]
        )
    )
RETURN
IF (
    'YourTable'[Value Date] = MaxValueDate,
    'YourTable'[Due Date],
    BLANK ()
)

Here's a link to a working file: https://drive.google.com/file/d/1yiOzEV_mh5jesxaYQkeYUnbTgxKxlNhS/view?usp=sharing

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.