Forum Discussion

GabinAM's avatar
GabinAM
Frequent Visitor
2 years ago
Solved

Power Querry - Replace a boolean value True or False

Hello everyone ! ğŸ˜Š I'm trying to replace boolean values based on another column condition.However and despite the absence of error, there is no modification at all on the table (the formula works...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    = Table.ReplaceValue(#"Changed Type",each [Direct Contact],each if List.ContainsAny({"Jodie","Anthony","Jonathan"},{[Sales]}) then false else [Direct Contact]   ,Replacer.ReplaceValue,{"Sales", "Direct Contact"})
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

HEllo GabinAM ,

 

can you try to replace false with "false"

  • GabinAM's avatar
    GabinAM
    Frequent Visitor
    2 years ago

    Hello! I tried and indeed, it works on the test sample ! ğŸ˜…

    However, I think I forgot one key point... the column [Direct Contact] is Data Type = True/False and Under this format, the "false" doesn't work anymore... Please see below. 


    I updated the Pbix in the dropbox folder. here 

     
    Sorry and thank you again for you help!