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_ServiceLe...
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!
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!