cancel
Showing results for
Did you mean:
Frequent Visitor

## Cumulative SUM by Month by contrat

Hi, sorry for my english, i'm french.

I have a table like this and i would calculate the column "Montant cumulé". So, for each Month, the cumulative amount per Month and per N°Contrat.. Can you help me to found the DAX formule for the yellow Column plesae ?

Thanks for helping.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Cumulative SUM by Month by contrat

```[Montant cumule] =
var __noContrat = selectedvalue ( T[N°Contrat] )
var __currentDate = max ( T[Date] )
var __cumule =
SUMX(
FILTER(
ALL ( T ),
T[N°Contrat] = __noContrat
&&
T[Date] <= __currentDate
),
T[Montant]
)
return
__cumule```
6 REPLIES 6
Super User

## Re: Cumulative SUM by Month by contrat

```[Montant cumule] =
var __noContrat = T[N°Contrat]
var __currentDate = T[Date]
var __cumule =
SUMX(
FILTER(
T,
T[N°Contrat] = __noContrat
&&
T[Date] <= __currentDate
),
T[Montant]
)
return
__cumule```
Frequent Visitor

## Re: Cumulative SUM by Month by contrat

Hi, thanks

but i have another dufficult, i have try your solution but when i have more amount in the same month with négative value, it's no good.

For exemple, with this table :

I must have for N°Contrat C002 a cumulative value of 130.

But with your formule, i have 260 :

Thank you very much for your help.

Super User

## Re: Cumulative SUM by Month by contrat

What I've given you is a CALCULATED COLUMN, not a measure. You did not say a single word about a measure.

Best
Darek
Frequent Visitor

## Re: Cumulative SUM by Month by contrat

I'm sorry.

Can you help me ?

Super User

## Re: Cumulative SUM by Month by contrat

```[Montant cumule] =
var __noContrat = selectedvalue ( T[N°Contrat] )
var __currentDate = max ( T[Date] )
var __cumule =
SUMX(
FILTER(
ALL ( T ),
T[N°Contrat] = __noContrat
&&
T[Date] <= __currentDate
),
T[Montant]
)
return
__cumule```
Frequent Visitor

It's ok !!!

Announcements