Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I need to create a formula that will help me deduct refund amounts from the purchases. All the transaction amounts are in one column, there is a refund attribute that is tracked in another column. How do I get Power BI to deduct the refunds so that we can get an accurate net income for the day? I have the date filters all built, just can figure out how to do the math to deduct the refund.
This is adding them
These are the columns
Solved! Go to Solution.
There are a few ways. Probabaly easiest is to write a measure (or two)
total raw amount= sum(apprasialaccount(amount)
total sales =calculate([total raw amount],appraisalaccount[refund]=“False”)
total refunds = -calculate([total raw amount],appraisalaccount[refund]=“True”)
total amount = [total sales]+[total refunds]
note the negative sign in front of refunds
All working now, Tanks
There are a few ways. Probabaly easiest is to write a measure (or two)
total raw amount= sum(apprasialaccount(amount)
total sales =calculate([total raw amount],appraisalaccount[refund]=“False”)
total refunds = -calculate([total raw amount],appraisalaccount[refund]=“True”)
total amount = [total sales]+[total refunds]
note the negative sign in front of refunds
Hi, I have a similar problem, only I need to produce counts of transactions. With my data the refunds balance out, but the original transaction and the refund will be counted as two transactions - I want to count them as 0 transactions. How would I get around this?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |