Replace the last digital with "1" if 0

[ngct1112]

Hi all, may I know if there is any way I could replace the number if the last digit is "0" then replace with 1

using query like this 

= Table.ReplaceValue(#"Changed Type",each [QTY],
if Text.End(Text.From([Text], "en-HK"), 1) = 0 then 1))

QTY	QTY-modify
2500	2501
2501	2501
5000	5001
5001	5001
7500	7501
1000	1001
5000	5001

Great thanks!

[ngct1112]

@Anonymous thanks for your help.

I have also try another option which could be applicable

= Table.ReplaceValue(#"Changed Type", each [QTY], each if Text.End(Text.From([QTY]), 1) = "0"  then 
    [QTY]+1 
    else [QTY],Replacer.ReplaceValue,{"QTY"})

[v-kelly-msft]

Hi @ngct1112 ,

If your issue is solved ,could you pls mark the correct replies as answered to close it?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous · Accepted solution]

Hi @ngct1112 

Add a custom column

if Text.End(Text.From([QTY]), 1) = "0" then [QTY]+1 else [QTY]