Forum Discussion

mjonesjr8's avatar
mjonesjr8
Frequent Visitor
4 years ago
Solved

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 ...
Need Help
  • mjonesjr8's avatar
    mjonesjr8
    4 years ago

    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's avatar
    Hariharan_R
    4 years ago

    Hi mjonesjr8 

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

    Thanks

    Hari

Hariharan_R's avatar
Hariharan_R
Solution Sage
4 years ago

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's avatar
mjonesjr8
Frequent Visitor
4 years ago

Okay, I see, thank you very much!