Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Frormatting column A based off text in column B

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 hav...
Need Help
Aree's avatar
Aree
Icon for Resolver I rankResolver I
7 years ago

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.