Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX if statement syntax error

I am new to Power BI ... I am tyrying to insert a new custom column into a table in the Query Editor. The Column should extract data from an excisting column based on an "IF" Statement with an "CONTA...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous Please note "Power Query" expressions are case sensitive.  "IF" not same as "if", please correct the all keywords in your expression.

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

Anonymous

 

looks like you're using Power Query and not DAX

 

try this:

 

= if Text.Contains([Conent],"SHOWS") then "SHOWS" else if List.Contains({"DRY","WATER"},[Content]) then "DRY" else "HC"

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes I'm working in PowerQuery... (I thought this was the same)

 

I've tried several approaches nothing seems to work..

My Column conatins 12 unique types of entry (text), all those rows containing the words "SHOWS" should be returned as "SHOWS". Entries with "DRY" or "WATER" should return "DRY", all other entries should Return the value "HC"

 

Keep getting Syntax errors I don't understand... is the syntax case sensative, when should I use IF.. Then and Else rather than commas

 

 

(This is an Oil industry problem... in case you were wondering)

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    Anonymous Please note "Power Query" expressions are case sensitive.  "IF" not same as "if", please correct the all keywords in your expression.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    SUCCESS... all in order....

    Many thanks for your help... I've a long way to go on the learning curve