Turning some values in a column into negatives based on a condition

[Rag_G]

Hi,

Please refer to the picture i have attached. 

All values in the "Quantity" column are positive however i need some to be negative based on the "Type" column. 
Eg. If the "Type" column shows "GR" return the same value in the "Quantity" column, but negative.

Does anyone know how this can be done? Thank you in advance! 

[v-piga-msft · Accepted solution]

Hi @Rag_G ,

For your logic, you could create a calculated column with the formula below.

 Column = if('Table'[type]="GR",[Quantity],-1*[Quantity])

Here is my test output based on your data sample.

Best Regards,

Cherry