If Formula with a range?

[Anonymous]

I have 2 measures. 

Measure 1: Time = DATEDIFF([ERDAT],[CLDAT1].[Date],DAY)

Measure 2:  Target = IF([Time]<=21,"in time","overdue")

If CLDAT1 is empty than Measure 2 shows as well "in time". Which is wrong. It should be either be empty  or a text "in progress".

Any idea is welcome.

[Anonymous · Accepted solution]

If CLDAT1 is empty does that make Time empty?

If so, try:

Target = IF(ISBLANK([Time]),BLANK(),IF([Time]<=21,"in time","overdue"))

Or

Target = IF(ISBLANK([Time]),"in progress",IF([Time]<=21,"in time","overdue"))