Need Help with converting an Excel Formula to Dax

[emembreno81]

Hello!

I'm currently working to move a report that I currently run in Excel into Power BI.  I'm currently working to convert a rather complex formula into DAX.  Can someone help guide me on how to rewrite the following formula into DAX?

=IF(OR(ISNUMBER(SEARCH({"tbd"},Y5)),Y5="",),"INCOMPLETE","COMPLETE")

Thanks!

[onurbmiguel_]

Hello emembreno81

try sometihing like that:

measure_1 = 
var _value = 
if( table[column_Y5] = "" || table[column_Y5] = "tbd" , "INCOMPLETE","COMPLETE")

return 
_value

If the measure don´t work please send some exmaple of you model e data. 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC 

[emembreno81]

That worked!  Thank you so much!

[onurbmiguel_]

Hello 

Please accept my solution and give me Kudos if possible. 

Thanks 

Bruno

[emembreno81]

Hi Bruno! 

So - I've actually now double checked the formula you provided and it looks like the OR functionality is not working in the formula your provided.  It looks like the formula is excluding any case where both elements are not true where as I want it to look for instances where either one of the two portions of the formula are true.  Do you know what may be causing that?

[emembreno81]

I have a feeling the formula is looking for instances where the data in the column is "tbd" ONLY - but I need to find instances where "tbd" is part of the information in the data.   - so not just looking for "tbd" but also for example "tbd15" or "tbd blue"