Sum columns with range

[Mrvisible]

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 ?

[Vvelarde]

@Mrvisible

Hi, try with this in Query Editor

Regards

Victor

[Greg_Deckler]

Where is invoice 399 in that image???

[Mrvisible]

sorry, Post edited

[Mrvisible]

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]

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