Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 wit...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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's avatar
    AndrewDavies437
    4 years ago

    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!

     

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,


    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's avatar
AndrewDavies437
Helper I
4 years ago

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!