try otherwise ，It looks like the result is wrong

[王小飞]

Hello，expert

Look at the simulated data, it seems otherwise not executed

[Ahmedx]

look at my video
https://1drv.ms/v/s!AiUZ0Ws7G26RhyeGSYdbu2BYXd6s?e=vLE1Q0

try [AGE2] catch(rt)=> if rt[Message]="We couldn't convert to Number." then [AGE1] else[AGE2]

[王小飞]

Hello，

I can not open this video。please confirm

 Thank you

[v-xinruzhu-msft · Accepted solution]

Hi @王小飞 

You need to put the try.. otherwise inside the Table.addcolumn

e.g 

= Table.AddColumn(#"Changed Type", "Custom", each try [AGE2] otherwise [AGE1])

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.