cancel
Showing results for
Did you mean:
Helper I

## If Formula with a range?

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Resolver II

## Re: If Formula with a range?

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"))

Resolver II

## Re: If Formula with a range?

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"))

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors