Forum Discussion

gtamir's avatar
gtamir
Post Patron
8 years ago
Solved

if is null

I want to use the expresion "if is null" to replace the "mobile" column with null, with the value in the same row in column "phone".
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago
    Hi
    I test using a simple dataset as follows.
    In Query Editor->Advanced editor
    add code
    mobile= Table.ReplaceValue(#"Changed Type",each [mobile], each if [mobile]=null then [phone] else [mobile] , Replacer.ReplaceValue,{"mobile"})
    #"Changed Type"->this table
    you will see
     
    Best Regards
    Maggie
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago
Hi
I test using a simple dataset as follows.
In Query Editor->Advanced editor
add code
mobile= Table.ReplaceValue(#"Changed Type",each [mobile], each if [mobile]=null then [phone] else [mobile] , Replacer.ReplaceValue,{"mobile"})
#"Changed Type"->this table
you will see
 
Best Regards
Maggie