Convert bytes into gigabytes

[NicholasPowerB]

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 · Accepted solution]

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.