Forum Discussion

NicholasPowerB's avatar
NicholasPowerB
New Member
3 years ago
Solved

Convert bytes into gigabytes

Hello everyone 🙂 

I am struggling with a query and i am looking for any help, tip or ideas. 

I am trying to convert a specific number- 8589934592 into gigabytes.

Open for any tips, ideas and suggestions

Thank you

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi NicholasPowerB 

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WsjC1sLQ0NjG1NFKK1YlWMtQzMjZRio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [num = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"num", type number}}),
    Custom1 = Table.TransformColumns(#"Changed Type",{"num", each if _ = 8589934592 then _/1000000000 else _})
in
    Custom1

    Output

     

    Best Regards!

    Yolo Zhu

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

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi NicholasPowerB 

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WsjC1sLQ0NjG1NFKK1YlWMtQzMjZRio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [num = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"num", type number}}),
    Custom1 = Table.TransformColumns(#"Changed Type",{"num", each if _ = 8589934592 then _/1000000000 else _})
in
    Custom1

    Output

     

    Best Regards!

    Yolo Zhu

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