Calculate amount gradually

[Anonymous]

Hello everyone,

i would like to put in my report the order amount calculated gradually. I explain my wishes:

my tables:

On the left side, the order amount. On the right side the bill amount. (relation 1 to many)

I'd like to calculated the remains to be billed for my order and display it in a report which display month by month the sum of this remain to be billed for all my orders.

What i am waiting to have is something like that:

What should i do? A calculated column ? A measure?

How to write the DAX formula?

Thx for your help.

Fred

[AllisonKennedy · Accepted solution]

Do you have a DimDate table in there somewhere?
If I understand your question correctly, you're looking for a Running Total, see if this link helps you:
https://www.sqlbi.com/articles/computing-running-totals-in-dax/