Forum Discussion
Solved
Lookupvalue with a datevalue zero
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?
Can you help me?
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!
1 Reply
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!