Column with Duplicate Dates

Question

Hello,&nbsp;I have a report created with the following columns.Report DateFacility CodeValue DateOutstanding AmountDue DateDue Date Final (New Column)&nbsp;&nbsp;I am trying to create a formula in the "Due Date Final" column where it pulls the due date only once.&nbsp;Currently, the due date pulls into every row. I want it to pull into the row which contains the latest value date of the Facility Code by Report Date.&nbsp;&nbsp;&nbsp;Please note, there is a slicer added the visual which is the "Report Date" column. We filter the report by Report Date.&nbsp;&nbsp;Report DateFacility CodeValue Date&nbsp;Outstanding AmountDue DateDue Date Final11/7/2025745817/1/2025&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (359,013.21)10/26/2027&nbsp;11/7/2025745819/19/2025&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (4,700,000.00)10/26/2027&nbsp;11/7/2025745819/29/2025&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (8,000,000.00)10/26/2027&nbsp;11/7/20257458110/1/2025&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (238,223.29)10/26/2027&nbsp;11/7/20257458110/14/2025&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (100,000.00)10/26/202710/26/2027

tayloramy · Accepted Answer

Hi&nbsp;gmasta1129,&nbsp;&nbsp;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 ()
)&nbsp;&nbsp;Here's a link to a working file:&nbsp;https://drive.google.com/file/d/1yiOzEV_mh5jesxaYQkeYUnbTgxKxlNhS/view?usp=sharing&nbsp;If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Forum Discussion

Column with Duplicate Dates

1 Reply

Related content

Duplicate Dates in Date column

Duplicate ranking

Merge duplicates data in columns

Column count duplicates

Find Most Recent Date Relative to another Date Column in Power Query

Report Date	Facility Code	Value Date	Outstanding Amount	Due Date	Due Date Final
11/7/2025	74581	7/1/2025	(359,013.21)	10/26/2027
11/7/2025	74581	9/19/2025	(4,700,000.00)	10/26/2027
11/7/2025	74581	9/29/2025	(8,000,000.00)	10/26/2027
11/7/2025	74581	10/1/2025	(238,223.29)	10/26/2027
11/7/2025	74581	10/14/2025	(100,000.00)	10/26/2027	10/26/2027