cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Get Positive and Negative Value from 1 column

Hi Everyone,

I want to get positive and negative values from 1 column to new column. For the picture below new column return is "True" and "False" but I want that to return Number value, please advice.

Thank you.

Example.

If CM1 < 0 then column Cost CM1 is get value CM1 < 0 (negative value) and If CM 1 > 0 then column Cost CM1 is get value CM1 > 0 (positive value).

```Cost CM = SWITCH(TRUE(),
[ CM1] < 0, [ CM1] <= 0,
AND([ CM1] > 0, [ CM2] < 0), [ CM1] > 0,
BLANK()
)```

1 ACCEPTED SOLUTION
Community Support

Hi hanami001,

If my understand is right, you want to create a calculate column which can return value of [CM1] based on some conditions right?

To achieve your requirement, please create a calculate column and use DAX:

Cost CM = SWITCH(TRUE(),

Table1[CM1] < 0, [CM1],

AND(Table1[CM1] > 0, Table1[CM2] < 0), [CM1],

BLANK()

)

You can refer to PBIX:

https://www.dropbox.com/s/cf9v7xkupx0fikd/For%20hanami001.pbix?dl=0

Regards,

Jimmy Tao

2 REPLIES 2
Community Support

Hi hanami001,

If my understand is right, you want to create a calculate column which can return value of [CM1] based on some conditions right?

To achieve your requirement, please create a calculate column and use DAX:

Cost CM = SWITCH(TRUE(),

Table1[CM1] < 0, [CM1],

AND(Table1[CM1] > 0, Table1[CM2] < 0), [CM1],

BLANK()

)

You can refer to PBIX:

https://www.dropbox.com/s/cf9v7xkupx0fikd/For%20hanami001.pbix?dl=0

Regards,

Jimmy Tao

Frequent Visitor

Hello Jimmy Tao,

It worked, Thank you. ^-^

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors