Forum Discussion
DAX if statement syntax error
Anonymous Please note "Power Query" expressions are case sensitive. "IF" not same as "if", please correct the all keywords in your expression.
I've tried both... and although there are no syntax error detected I still getr the message "Expression.Error: The name 'IF' wasn't recognised....."
Do I need to specify the Table name in the formula, seeing as this is a given
Solution SageAnonymous
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"
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
Community Champion
Anonymous Please note "Power Query" expressions are case sensitive. "IF" not same as "if", please correct the all keywords in your expression.
SUCCESS... all in order....
Many thanks for your help... I've a long way to go on the learning curve