Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 , 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])))
This one work perfect, thank you 🙂
Mesarue = calculate(lastnonblankvalue(Plan_T[Skjutdatum], max(Plan_T[Krans])), allexcept(Plan_T, Plan_T[Ort]))