Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 2 columns , sales and Profit with postive and negative values for both.. I need to create a measure in power bi Desktop to find the difference (Sales - Profit).... Our difference will contain negative and postive numbers... Now my query is how to consider the negative numbers as positive and sum them up with postive numbers.. Please find the attached screeshots. Please note difference is not a column , its a measure to be calculated in power bi. i am not able to attach excel .hopefully someone can help me in the community.. Thanks
Solved! Go to Solution.
I think @AlexisOlson it needs one more step to get the rows responding the same way as presented:
I think @AlexisOlson it needs one more step to get the rows responding the same way as presented:
Thankyou so much...Thompson 🙂
Do you need your difference measure to preserve the sign at the individual product level or can you do this?
AbsDiff = SUMX ( VALUES ( Table1[Product] ), ABS ( [Sales] - [Profit] ) )
Where [Sales] and [Profit] are appropriately defined measures, e.g. Sales = SUM ( Table1[Sales] ).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
76 | |
66 | |
60 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |