Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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] ).
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |