Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
I have two Columns Column 1 and Column 2. When I subtract them using data formula = Subtract [Column1]-[Column2] I get - sign.
An example can be
Column 1 Column 2
31 113 Answer I get is -82
I understand this is how math works but the columns I have will always have different numbers. How do I remove - sign so it will not appear? Please help.
Solved! Go to Solution.
How about ABS ( [Column 1] - [Column 2] ) ?
You are the best, problem solved.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |