Repeat the most recent data point and corresponding month.

[Add1]

I community. I need a bit of guidance. I have this dataset within the screenshot. I need to create a dynamic way to pull the most recent Preventative Maintenance numbers and the corresponding month when updated data is provided. In the screenshot, is what I want my final result to be... repeating Oct:343, until someone actually updates the table.

Below is the code that I created so far.

Any assistance would be great!

Thank you

3 Test = VAR LatestPMValue =

    VAR MaxSortOrder = MAX('Facilities - Test'[Sort Order])

    VAR Index = 1

    VAR LatestPMValue2Measure2 = lookupvalue('Facilities - Test'[Preventative Maintenance],'Facilities - Test'[PMIndex],max('Facilities - Test'[PMIndex]))                         VAR PrevMaintenance =

        LOOKUPVALUE(

            'Facilities - Test'[Preventative Maintenance],

            'Facilities - Test'[Sort Order],

            MaxSortOrder - Index

        )

    VAR Month =

        LOOKUPVALUE(

            'Facilities - Test'[Month],

            'Facilities - Test'[Sort Order],

            MaxSortOrder - Index

        )

    VAR Result =

        IF(

            ISNUMBER(PrevMaintenance),

            LEFT(Month, 3) & ": " & PrevMaintenance,

            BLANK()

        )

    RETURN

        Result

RETURN

    LatestPMValue

[Add1 · Accepted solution]

I found the solution. I created a calculated table that pulled in the sort order, month, and preventative maintenance. I also added a column that produces the needed result. Then I created a DAX measure used the lookupvalue function to pull the last data point.