Net amount based on 2 columns

[mjonesjr8]

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

[mjonesjr8 · Accepted solution]

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.  

[Hariharan_R]

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 Linkedin

[mjonesjr8]

Okay, I see, thank you very much!

[mjonesjr8 · Accepted solution]

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.  

[Hariharan_R · Accepted solution]

Hi @mjonesjr8 

As you already has negative values, sum  of amount will give 120. 

Thanks

Hari

[mjonesjr8]

Thank you very much!