Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.