Is it possible to get an “selectedvalue” in a DAX formula with LOOKUPVALUE?
The problem is that I would like to have the First MileageKms for a particular vehicleID/ licenseNo in a particular period. I tried the function Lookupvalue, but I can’t get the searchvalue for the VehicleID correct (340, then 334, then 337 – based on the context) in the function.
Mileage search (FIRST DATE) = LOOKUPVALUE(RefuellingStops[MileageKms];RefuellingStops[VehicleId];340;RefuellingStops[Moment];[First date])
Greetings Marc from the Netherlands