Creating a new Column to show both Positive and negative values

[Anonymous]

Hi,

I would like to know if there is a way I can create a column and assign both positives and negative values based on another Column.

here is a hypothetical there is a column laballed DRCRcode and another labelled Amount. I would like to create  another column that will reference DRCRcode and return a positive or negative into the new column.

I tried this formula but it's not getting the job done 

AMOUNT_ = IF(TRNX_DETAILS_20_FACT[DRCRCODE]="C",TRNX_DETAILS_20_FACT[AMOUNT]*-1,TRNX_DETAILS_20_FACT[AMOUNT])

[v-shex-msft]

HI @Anonymous,

Your formulas is a calculated column, please double check you are use it in 'calculated column' expressions and the fields it invoked are numeric types that can be calculated with math operators.

In addition, what connection mode are you work with? AFAIK, direct query mode has limited the DAX function usage in calculated column expression.
Regards,

Xiaoxin Sheng

[harshnathani · Accepted solution]

HI @Anonymous ,

I do not see any error in your formula. Are you creating a Calculated Column or a Measure. Please click on New Column.

Mine works fine

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)