topic DAX function in DAX Commands and Tips

DAX function

deys — Wed, 21 Jul 2021 16:06:06 GMT

HI,

I am new to PWBI DAX function. Can anyone help me with correct DAX function to show this number "-0.7%" as (0.7%).

Thanks,

Simky

jthomson — Wed, 21 Jul 2021 16:22:17 GMT

Sounds more like a measure formatting issue rather than requiring a specific function to do it.

For future reference, a more descriptive thread title would be useful, we kind of know the question will be about a DAX function in the DAX forum

community_pinki — Wed, 28 Jul 2021 12:24:56 GMT

Hey deys ,

You can use the ABS function (absolute value).

You can also multiple by -1, "[Column] * -1"

With ABS you could get rid of negative numbers while not impacting the positive numbers.