subtract refunds from purchases

[Anonymous]

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

[MattAllington · Accepted 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

[Anonymous · Accepted solution]

All working now, Tanks

[MattAllington · Accepted 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

[luciefialova]

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?