Forum Discussion

bhushan_7's avatar
bhushan_7
New Member
3 years ago

All characters after 15 characters getting converted into zeros after changing data type to text

Hi,   I have numbers in excel (data source). Numbers are of various lengths. In all numbers where characters are more than 15, automatically zeroes appear, replacing any characters present in the o...
Need Help
serpiva64's avatar
serpiva64
Solution Sage
3 years ago

Hi,

this is what you get by adding a custom column

= Table.AddColumn(Source, "Custom.1", each if Text.Length([Column1]) <= 15 then [Column1] else Text.Start([Column1],15)& Text.Repeat("0",Text.Length([Column1])-15))

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!