Measure that shows the last value in a serie based on date in another one

[Petter120]

Hi, 

I have a table with the columns: Drift, Ring and date.

I need help to create a measure that will show the last ring in in every drift (by date)

Best regards 

Petter 

[amitchandak · Accepted solution]

@Petter120 , Try measure one of the three with drift

lastnonblankvalue(Table[Date], max(Table[ring]))

calculate(lastnonblankvalue(Table[Date], max(Table[ring])), allexcept(Table, Table[Drift]))

calculate(lastnonblankvalue(Table[Date], max(Table[ring])), filter(all(Table), Table[Drift] =max(Table[Drift])))

[Petter120]

This one work perfect, thank you 🙂

Mesarue = calculate(lastnonblankvalue(Plan_T[Skjutdatum], max(Plan_T[Krans])), allexcept(Plan_T, Plan_T[Ort]))