Solved: Need Help

netanel · ‎03-22-2020

Hello everyone,
I have a little problem...
I'm having a bit of trouble in the new version to solve this.
I'm trying to multiply one column by minus 1 to make all the minuses a plus.
can anyone help me?

Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki

amitchandak · ‎03-22-2020

Measure = abs([col1]*-1 )

https://docs.microsoft.com/en-us/dax/abs-function-dax

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Greg_Deckler · ‎03-22-2020

Can you just use ABS function? ABS([Column])

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

amitchandak · ‎03-22-2020

Measure = abs([col1]*-1 )

https://docs.microsoft.com/en-us/dax/abs-function-dax

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

netanel · ‎03-22-2020

Maybe I did not explain myself well, I want to exchange signs
Instead of minus plus
And instead of a plus minus

Thanks for your time

Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki

littlemojopuppy · ‎03-22-2020

second column = [first column] * -1

You could actually prevent the need for this entirely within your data model by multiplying the value by -1 in the data transformation process