Insert Decimal

Hi ThisIsIt 

if the length of the whole number differs you can do it with Power Query like this:

// Table
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyNjE1M7dQio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Value = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Start([Value],2) & "." & Text.End([Value],Text.Length([Value])-2)),
    #"Changed Type" = Table.TransformColumnTypes(#"Added Custom",{{"Custom", type number}})
in
    #"Changed Type"

or you can do it with DAX:

Decimal Number = 
CONVERT (
    LEFT ( CONVERT ( 'Table (2)'[Value], STRING ), 2 ) & "."
        & RIGHT (
            CONVERT ( 'Table (2)'[Value], STRING ),
            LEN ( CONVERT ( 'Table (2)'[Value], STRING ) ) - 2
        ),
    DOUBLE
)

A shorter version of the above DAX formula is:

Decimal Number = 
CONVERT (
    LEFT ( 'Table (2)'[Value], 2 ) & "."
        & RIGHT (
            'Table (2)'[Value],
            LEN ('Table (2)'[Value] ) - 2
        ),
    DOUBLE
)

Regards FrankAT