cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper V

## Rewrite IF function

Hi all,
I’m currently struggling to rewrite this excel formula to DAX.
Excel formula
IFERROR( IF(A2-B2 >= -1, “Yes”, IF ( B2 = “ “, “No”, “No”)), “No”)

I’ve tried to write in DAX, but I’m getting different count

IFERROR(IF(Table1[Date1] - [Date2] >= -1, “Yes”,
IF([Date2] = BLANK(), “No”,”No”)),”No”)

Thanks much!
1 ACCEPTED SOLUTION
Responsive Resident

Perhaps

IF(  Table1[Date1] - Table1[Date2] < -1 || ISBLANK(Table1[Date2]), "No", "Yes")

4 REPLIES 4
Community Champion

@Stuznet

Are you sure it is blank and not just an empty cell?

Maybe the following?

```IFERROR(IF((Table1[Date1] - Table1[Date2]) >= -1, "Yes",
IF(OR(Table1[Date2] = BLANK(), Table1[Date2]="", LEN(Table1[Date2]) = 0), "No","No")),"No")```
Responsive Resident

Perhaps

IF(  Table1[Date1] - Table1[Date2] < -1 || ISBLANK(Table1[Date2]), "No", "Yes")

Helper V
Thank you so much your solution works great 🙂
Super User

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors