Forum Discussion
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
- MrvisibleNew Member
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_DecklerCommunity Champion
Still don't see a 399 in that image, or; for that matter, any of the other numbers you mention.
- Greg_DecklerCommunity Champion
Where is invoice 399 in that image???
- MrvisibleNew Member
sorry, Post edited
- VvelardeCommunity Champion