Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

IF

Hi trying to create    =IF(table[ordertypeD] = "Normal Order"), table[feild],"")   Getting an error on "Normal Order"  Yet Normal Order exists in table[ordertypeD]   In fact I get an error as ...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    Try

    =IF(table[ordertypeD] = "Normal Order", table[feild],blank())

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

Try

=IF(table[ordertypeD] = "Normal Order", table[feild],blank())

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Pranit, no mate issue is not the blank "".....DAX is not recognising "Normal Order" 

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks mate....Syntax worked though was still getting the feilds appear red....Forgot to mention was DAX being used in Excel....The feilds stayed RED but the syntax worked and returned the desired result...thank you....!