Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
@Vera_33 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"})
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!