Forum Discussion
Function IF error in add step
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
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é"]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!
3 Replies
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é"]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!