cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deys
New Member

DAX function

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

2 REPLIES 2
community_pinki
Advocate I
Advocate I

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.

jthomson
Solution Sage
Solution Sage

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.