topic Re: How can I convert negative value to zero in DAX Commands and Tips

How can I convert negative value to zero

kati70 — Thu, 20 Oct 2016 13:47:08 GMT

Hi,

I couldn't find a solution for this, so I really do hope that someone can support with this.

I have calculation where negative values should be converted to zero. Any ideas?

Thanks a lot,

-Kati

Re: How can I convert negative value to zero

skasper — Thu, 20 Oct 2016 13:52:08 GMT

Have you tried adding a conditional column? See example below. Of course with your own column names. I am the first to admit that this is not very elegant, but it should work until you have a better solution.

Re: How can I convert negative value to zero

epieters — Wed, 07 Dec 2016 21:53:00 GMT

Test if the number is negative, and if so, add the abolute value of that number.

That will give you the zero.

IF( [Number] < 0, [Number] + ABS( [Number] ), [Number] )

Cheers,

--Eric.

Re: How can I convert negative value to zero

Baskar — Fri, 23 Dec 2016 04:08:39 GMT

Ya we can do .

If ( measure < 0 , 0 , measure )

thats it.

let me know if any further help.

Re: How can I convert negative value to zero

Anonymous — Tue, 19 Jan 2021 16:41:53 GMT

I am wondering if this is the optimal way or if using the function max( measure, 0) performs quicker.

(apologies for ressurecting an old thread!)