how to use if clause in power query?

[dsandip]

Hi,

I have used below in my Power Query:

Table.AddColumn(#"Changed Type3", "Custom Consumer ID", each if each Text.Contains([DIM_OPS_CNDCT_PRODUCT_KEY], "Package SME") = true then 2 else [DIM_SEGMENT_ID])

Now, I am getting error, at 

each if each Text.Contains([DIM_OPS_CNDCT_PRODUCT_KEY], "Package SME") = true

as 

"Expression.Error: We cannot convert a value of type Function to type Logical.
Details:
Value=[Function]
Type=[Type]"

Can any one help me that, how can I write that IF then ELSE cuase.

Thanks,

Sandip

[_AAndrade · Accepted solution]

Hi,

According with error message the problem is here: 

Try to delete thar "each"

[dsandip]

just overlooked the extra each