Forum Discussion

elfunambolo83's avatar
elfunambolo83
Regular Visitor
3 years ago
Solved

Remove last digits

Hello, I want to remove last 15 digits from the right. I tried to use Split column with By Positions fuction but I'm not sute how to use it.   Thanks for support   Regards, Giovanni    ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    please write the column name like this [#"All: Net Profit"]

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

elfunambolo83 
>> First change data type decimal to text >> create new column >> Using Text.Range function in M Code >> then change new column datatype text to decimal >> get your output.


* If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.