Forum Discussion

Mrvisible's avatar
Mrvisible
New Member
8 years ago

Sum columns with range

Hey,

 

i've been trying to do this in powr bi for quite a while now, and exact no success

 

 

let's take the example of the invoice 405, as you can see in the same line is the total value of the note fical, and below are the items that make up this value, so if you add 32,91+10,97 , it will give you the value of the invoice..

My question is how to do that for every INVOICE ?

5 Replies

  • Hey,

    I've been struggling on how to do this in POWER BI, My end goal is to compare the values of the items with the total value of the invoice.. i'll give you an example:

     

     let's take the example of the invoice 399, as you can see in the same line is the total value of the note fical, and below are the items that make up this value, so if you add 49.5 + 22.24 until 16.55 it will give you the value of the invoice..

    My question is how to do that in power bi automatic per Invoice?

     

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion

      Still don't see a 399 in that image, or; for that matter, any of the other numbers you mention.