Convert bytes into gigabytes

NicholasPowerB — Wed, 09 Aug 2023 14:26:44 GMT

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

Re: Convert bytes into gigabytes

Anonymous — Fri, 11 Aug 2023 02:23:55 GMT

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.

topic Convert bytes into gigabytes in DAX Commands and Tips

Convert bytes into gigabytes

Re: Convert bytes into gigabytes