Date filling tricky challenge

Hi PowerRobots99 ,

Below is the code that returns you the value from the previous known week for the selected PO.
This is a calculated column that fills in values ​​that are empty.

Correct Date = 
VAR CurrentPO = [PO]
VAR CurrentReportDate = [ReportDate]
VAR PreviousReportDate =
    CALCULATE(
        MAX(comm[ReportDate]),
        FILTER(
            comm,
            comm[PO] = CurrentPO &&
            comm[ReportDate] < CurrentReportDate
        )
    )
VAR LastDateInPreviousReportDate =
    CALCULATE(
        MAX(comm[Dates]),
        FILTER(
            comm,
            comm[PO] = CurrentPO &&
            comm[ReportDate] = PreviousReportDate &&
            NOT(ISBLANK(comm[Dates]))
        )
    )
RETURN
    IF(
        ISBLANK([Dates]),
        LastDateInPreviousReportDate,
        [Dates]
    )

 Result:

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin