Lookupvalue with a datevalue zero

[Ad_456]

Hello, I have a table (smax_ServiceLevelTarget) where I want to lookup a value, where a datefield is zero (empty) :

The next statements gives no result:

 LOOKUPVALUE(

        smax_ServiceLevelTarget[Status],

        smax_ServiceLevelTarget[ParentId] , smax_Incident[ID] ,

        smax_ServiceLevelTarget[TargetType] , "TimeInGroup" ,

        smax_ServiceLevelTarget[Achievementdate], 0 )        

The result I want to see is in the first line of the table.
Can you help me?

[Idrissshatila · Accepted solution]

Hello,

You could try this

Measure = IF(MIN('Date'[Date] = BLANK(),smax_ServiceLevelTarget[Value])

If I answered your question, please mark my post as solution, Appreciate your Kudos!

Follow me on Linkedin