Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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
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
Hi @GilbertQ,
Actually I want each and every number has to be display when I choose tabular form.
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
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,
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 () ))).
Hi @CarolRamza,
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |