Forum Discussion

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

suggestions ?

General Comment

Anonymous
5 years ago
Hi Anonymous

Try

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

6 Replies

Anonymous
Not applicable
5 years ago
Hi Anonymous

Try

=IF(table[ordertypeD] = "Normal Order", table[feild],blank())
- Anonymous
  Not applicable
  5 years ago
  Hi Pranit, no mate issue is not the blank "".....DAX is not recognising "Normal Order"
- 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....!
Anonymous
Not applicable
5 years ago
- Anonymous
  Not applicable
  5 years ago
  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
Tahreem24
Super User
5 years ago
Anonymous ,

There is an Parenthesis error. It should be like:

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