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 sugg...
  • 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.

     

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.