Trying to remove characters from field

Hi Anonymous ,
Here are the steps you can follow：
There are two methods here:
Method 1:
1. Create calculated column.

Column =
var _1=
VALUE(
MID(
'Table'[USD],
2,6))
return
FORMAT(_1,"Fixed")

Result:

But the format is Text, because the results obtained by using the Format function are in Text format
https://docs.microsoft.com/en-us/dax/format-function-dax

Method 2：
1. Create calculated column.

Value =
VALUE(
MID(
'Table'[USD],
2,6))

2. Click on the newly created new column, select Column tools - 2 - the value will have two decimal points
This is the numeric format

If you need pbix, please click here.

Trying to remove characters from field.pbix

Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly