Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 perfectly to change non boolean values).
Could you please help ? Please find the Excel document and the Pbix here
Many thanks in advance ! 🙌
*If by any chance you also have a way to reduce the formula by avoiding "...or..." I would be very interested but I can deal with it !
Solved! Go to Solution.
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"})
Hi @Ahmedx it works! Just need to add one additional steps to change Data Type to Logical but otherwise, it's perfect! Many thanks for your help! Appreciate!
HEllo @GabinAM ,
can you try to replace false with "false"
Proud to be a Super User! | |
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!