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 t...
Need Help
Tips and Tricks
Tutorial Requests
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 

  • emembreno81's avatar
    emembreno81
    Frequent Visitor
    4 years ago

    That worked!  Thank you so much!

    • 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

      • emembreno81's avatar
        emembreno81
        Frequent Visitor
        4 years ago

        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?