Forum Discussion
Stuznet
Helper V
Helper VRewrite 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 gettin...
Perhaps
IF( Table1[Date1] - Table1[Date2] < -1 || ISBLANK(Table1[Date2]), "No", "Yes")
Greg_Deckler
Community Champion
Community ChampionI'm guessing you need to use "" instead of BLANK(). Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490