Forum Discussion
Post PartisanHow can I separate positive and negative values
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.
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
6 Replies
- GilbertQ
Super User
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-msftMicrosoft Employee
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
