Function IF error in add step

[LD1]

Hi everyone, 

I would like to add a new step in my table with "IF containsstring" function.

I mean : 

Currently i use "if([main table]="text","text",[resultat from on other table].

I tried with the formula "Containsstring" combined with IF but the result is not clear (message error bellow).

I am not sur but in "create new step" logic is different and i tried to work with "if, then, else" 

I try to combine 2 data that come from 2 different columns

It doesn't seem to work.

I hope I am clear.

Thank you in advance for your help,

LD

[Vijay_A_Verma · Accepted solution]

PQ is super case sensitive.

Following changes are required

1. IF needs to be replaced with if

2. = in Text.Contains needs to be replaced with comma

Hence, in your custom column, you need to input following

= if Text.Contains([#"Format commercial regroupé"],"DIGITAL") then "DOOH" else [#"Type d'activité"]

[AndrewDavies437 · Accepted solution]

IF in power query should be "if" (lowercase) and IF in DAX is uppercase. I appreciate this is confusing, has caught me out a few times too. 

The "=" sign won't work as Text.Contains takes in two parameters (seperated by a column). Just replace the "=" with a "," and you'll be all good. Good luck!

[v-stephen-msft · Accepted solution]

Hi @LD1 ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[AndrewDavies437 · Accepted solution]

IF in power query should be "if" (lowercase) and IF in DAX is uppercase. I appreciate this is confusing, has caught me out a few times too. 

The "=" sign won't work as Text.Contains takes in two parameters (seperated by a column). Just replace the "=" with a "," and you'll be all good. Good luck!

[Vijay_A_Verma · Accepted solution]

PQ is super case sensitive.

Following changes are required

1. IF needs to be replaced with if

2. = in Text.Contains needs to be replaced with comma

Hence, in your custom column, you need to input following

= if Text.Contains([#"Format commercial regroupé"],"DIGITAL") then "DOOH" else [#"Type d'activité"]