Minus sign in front of value where there is a certain text

[LFM]

Hello. I want to make a minus sign in front of a value in a column that corresponds to a text value in another column. Shown under I want make a "-" sign in front of all the numbers in lots when buy or sell is sell?

Like this:

Buy	2
Sell	-1
Sell	-3
Buy	2
Sell	-1

[Greg_Deckler]

Minus sign in front of a value that corresponds to... - Microsoft Fabric Community

[Kaviraj11]

Hi,

You can create a calculated column as below:

ColumnName=

SWITCH(TRUE(),TableName[Buy or Sell]="Sell",-ABS(TableName[Lots]),ABS(TableName[Lots]))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[DataNinja777 · Accepted solution]

Hi @LFM ,

There are multiple ways to achieve your required output, and one of them is to write a calculate column like below:

Sign = if('Table'[Text]="Sell",'Table'[Lots]*-1,'Table'[Lots])

I attach an example pbix file.  

Best regards,