IF

[Anonymous]

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 soon as i enter " 

suggestions ? 

[Tahreem24]

@Anonymous ,

There is an Parenthesis error. It should be like:

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

[Anonymous]

[Anonymous]

@Anonymous  check the datatype once in the data tab....some times it could be datatype issue as well. or paste the sample data 

Regards,

Husna

[Anonymous · Accepted solution]

Hi @Anonymous 

Try

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

[Anonymous]

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....! 

[Anonymous]

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