Forum Discussion
Net amount based on 2 columns
I am pretty new to PBI, This was in Excel, how can I get the samething in Power BI?
Thanks!
| Over/Short | Amount |
| O | $5.00 |
| S | ($5.00) |
| O | $0.23 |
| O | $19.99 |
| S | ($20.00) |
| S | ($0.21) |
| O | $20.00 |
| O | $0.01 |
| O | $100 |
| Net Amount | $120.02 |
Thanks for the reply but i'm not sure that will work. It needs to add up all the numbers and then subtract out the (S's short)amount to get the net total.
5 Replies
Hi mjonesjr8
Do you have any other columns in the table? Power BI by default aggregate the data and show you in the visual. You can create a measure like below. Even the default amount column will show you the expected result when you drag and drop. The below measure also will show you the expected result.
=SUM('<Table Name>'[Amount])
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My LinkedinThanks for the reply but i'm not sure that will work. It needs to add up all the numbers and then subtract out the (S's short)amount to get the net total.
Okay, I see, thank you very much!