How can I separate positive and negative values

[arvindyadav]

Hi All,

I have one column which contain postive as well as negative and I want to seperate those in different column .

So how can I separate that column.

Please help me out.

Regards,

Arvind.

[GilbertQ]

Hi @arvindyadav

In the Query Editor if you create a New Custom Column and put in the following where my column name is called 'My Number'

Number.Sign([My Number])

If the number is positive it will equal 1 and if negative it will equal -1.

You can then use this new column to seperate your values with the conditional column in the Query Editor

Here is the reference that I used: Number.Sign

[arvindyadav]

Hi @GilbertQ,

Actually I want each and every number has to be display when I choose tabular form.

Regards,

Arvind

[v-jiascu-msft · Accepted solution]

@arvindyadav,

Hi Arvind,

Do you mean this?

Positive =
IF ( MIN ( 'Table1'[Numbers] ) >= 0, MIN ( 'Table1'[Numbers] ), BLANK () )

Negative =
IF ( MIN ( 'Table1'[Numbers] ) < 0, MIN ( 'Table1'[Numbers] ), BLANK () )

If this isn't what you want, please post a sample and the result you want.

Best Regards!

Dale

[Henrietta]

Hello,

I have tried to apply this formula to my data, but I must get something wrong because the result is not what I would have wanted. 

I have the same type of data, pos and neg values in one coloumn and I would like to split them as in your example but the result that I get is the following:

Do you have some ideas on this?

Thanks,

[Anonymous]

Hi there,

I have tried using the above mentioned measure, but it is giving me an error.

The syntax for 'MIN' is incorrect. (DAX(IF ( MIN ( 'Original Data'[Amount] ) >= 0. MIN ( 'Original Data'[Amount] ) ), BLANK () ))).

[v-jiascu-msft]

Hi @Anonymous,

Maybe your scenario isn't the same with this one. Please create a new thread in this forum. Please provide some sample data and the result you want.

Best Regards,

Dale