Distinct search/lookup

hi Harry1980 

try to plot a table with the material column and a measure like this:

Standard Price = 
VAR _targetmonth = 9
VAR _targetyear =2021   // the first two lines could be replaced other ways
VAR _material = MAX(TableName[Material])
VAR _table =     
FILTER(
        TableName, 
        TableName[Material]=_material
            &&TableName[Year] = _targetyear
            &&TableName[Pe] <= _targetmonth
    )

VAR _month = 
MAXX(
    _table,
    TableName[Pe]
)
RETURN 
MAXX(
    FILTER(_table, TableName[Pe]=_month),
    TableName[ Standard price ]
)

i tried and it worked like this: