Frormatting column A based off text in column B

[Anonymous]

I have two columns on hard drive space one colum has the disk size eg (85) and the other has the the format EG (TB/GB) I need all the date to be in GB so I need a way to convers all the ones that have a TB in the column associated with disk size. because when it totals out is add 1.6 TB as 1.6 GB..

[v-xuding-msft]

Hi @Anonymous  ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue

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

[Aree]

Hey @Anonymous 

You can create a custom column that calculates it.

Size in GB = 
IF(Table1[UoM] = "GB", Table1[Size],
    IF(Table1[UoM] = "KB", Table1[Size]/1000000,
        IF(Table1[UoM] = "TB", Table1[Size]*1000)))

My test data look like this

I use a column called UoM (Unit of Measure) and this column is used my IF statement when generating the conversion into GB.

Hope this helps.