How vlookup last use of transportation services

[larencib]

Hi, i am just new in PowerBi but have some experience en Powerpivot

I would like to find out in a table the last use of a Platfom (a long vehicle, with a NumberPlate po Matricula in spanish), and calculate in wich location is .This information comes from a table that shows all movements of the platforms betweens different islands

First, i tried to determine, from each  platforms, wich is the number  of use. After that i tried to max this use to determine its last service. But i dont know how to select the last PC_centro of this MAx Use

I tried this formulas:

Uso = COUNTROWS(FILTER('tblextraedatospedido';tblextraedatospedido[FechaTope]<=earlier('tblextraedatospedido'[FechaTope])&&'tblextraedatospedido'[_PC_Matricula]=earlier(tblextraedatospedido[_PC_Matricula])))

MaxUso = max(tblextraedatospedido[Uso])

And i tried some different calculation (vlookup to search wich PC-centro match with Max Uso but doesnt works

Thanks

[v-sihou-msft · Accepted solution]

@larencib

According to your description, you want to get the last use PC_centro within each _po_Matricula. Right?

You can create a measure like below:

Last Use PC_centro =
VAR MaxDate =
    CALCULATE (
        MAX ( 'tblextraedatospedido'[FechaTope] ),
        ALLEXCEPT ( 'tblextraedatospedido', 'tblextraedatospedido'[_po_Matricula] )
    )
RETURN
    CALCULATE (
        MAX ( 'tblextraedatospedido'[PC_centro] ),
        FILTER ( 'tblextraedatospedido', 'tblextraedatospedido'[FechaTope] = MaxDate ),
        ALLEXCEPT ( 'tblextraedatospedido', 'tblextraedatospedido'[_po_Matricula] )
    )

Regards,

[larencib]

Many thanks, works perfectly !!!!