Forum Discussion

emembreno81's avatar
emembreno81
Frequent Visitor
4 years ago

Need Help with converting an Excel Formula to Dax

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!

Need Help
Tips and Tricks
Tutorial Requests

5 Replies

  • onurbmiguel_'s avatar
    onurbmiguel_
    Icon for Power Participant rankPower Participant
    4 years ago

    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 

      • onurbmiguel_'s avatar
        onurbmiguel_
        Icon for Power Participant rankPower Participant
        4 years ago

        Hello 

        Please accept my solution and give me Kudos if possible. 

         

        Thanks 

        Bruno