Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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?
Solved! Go to Solution.
Measure = abs([col1]*-1 )
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
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
| User | Count |
|---|---|
| 22 | |
| 21 | |
| 20 | |
| 20 | |
| 11 |
| User | Count |
|---|---|
| 62 | |
| 55 | |
| 46 | |
| 45 | |
| 35 |