How to add column into table that contains a rounded up number from another column in the same table

[Blue407]

I have a table containing a list of PC's, one of the columns is drive capacity in bytes. (Data export from Intune, via Graph)

How do I create a new column that contains a rounded up value based on the drive capacity?

Same challenge for memory, also in bytes.

Example data:

totalStorageSpaceInBytes
1021821583360
509722230784
509722230784
1002444947456
1021821583360
509722230784
509722230784
510770806784
509722230784
509722230784
509722230784
509722230784
509722230784
509722230784
509722230784
286129127424
509722230784
509722230784
509722230784
510586257408
261216010240

I'd like a new column called 'DriveCapacity' that contains the simplistic Gb calculation from this drive capacity.  Such as 1TB or 512GB

What is the syntax of a formula to do this?

[Blue407]

Thats perfect, thankyou!!

[Greg_Deckler · Accepted solution]

@Blue407 Try this:

Column = ROUNDUP( [totalStorageSpaceInBytes] / 1073741824, 0 ) & "GB"