Latest Value Measure not Working

Hi ArchStanton ,

1. Desktop --> home pane --> transform data --> transform data

2. Powerquery editor --> add column --> index column --> close and apply.

Modify the measure:

LatestValue18mths+ Closed = 
    VAR _lastindex = 
            CALCULATE(MAX('18mth+ Closed'[Index]),
            FILTER('18mth+ Closed','18mth+ Closed'[KPI] <> BLANK() )
            )
    RETURN
        CALCULATE(
                MAX('18mth+ Closed'[KPI]),
                FILTER ('18mth+ Closed', '18mth+ Closed'[Index] = _lastindex)
        )

and the output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum