Calculate last step of a order id

[yforti]

Dear all, good afternoon!

I'm having trouble calculating the last step for each order id (NroPedido2) in my table:

in addition to calculating the last step, the calculation must disregard the setp (APIHOST = sendParent), Therefore, the expected result would be:

[ryan_mayu · Accepted solution]

@yforti 

pls try this

Column =

VAR _last=CALCULATE(max('Table'[DateSession]),ALLEXCEPT('Table','Table'[NroPedido2]))

return maxx(FILTER('Table','Table'[DateSession]=_last),'Table'[APIHOST])

pls see the attachment below