How do I create another column/measure where > or < 0 is stated as 0?

[WestWinter]

Date	Variable	Value	score
3/31/2010	A	-0.11734	1
4/30/2010	A	-0.13158	2
5/31/2010	A	0.000848	1
6/30/2010	A	0.02021	5
7/30/2010	A	0.020486	-1
8/31/2010	A	0.032784	-3
9/30/2010	A	0.086358	-2
10/29/2010	A	0.091077	1
5/31/2010	A	0.000848	3
6/30/2010	A	0.02021	4
7/30/2010	B	0.034486	5
8/31/2010	B	0.031784	-1
9/30/2010	B	-0.049358	-2
10/29/2010	B	-0.077	0

As above - I want the values to be zero when score is less than zero instead of the negative value and vice versa... How should I do this?

[Anonymous · Accepted solution]

Hi @WestWinter ,

You can create a measure

Status Measure = IF(MAX('Table'[Value])>0||MAX('Table'[Value])<0,0)

Or a calculated column

Status Calculated Column = IF([Value]>0||[Value]<0,0)

But I'm not sure what is the meaning of you doing this, maybe I understand it wrong?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@WestWinter , Based on what I got , a new column

Value 1 = if([Value]<0, 0, [Value])

[WestWinter]

@amitchandak Hi Amit,

I updated my question - got it wrong the first time, apologies

[amitchandak]

@WestWinter , Can you share expected output

try

Value 1 = if([score]<0, 0, [Value])