Cumulative total

[Pucca121]

Hi everyone!

I am new working with Power BI and I have a problem. My cumulative amount dosen't work when I add the date.  Does someone know why?

My formula of date:  DATE= CALENDARAUTO ()

My cumulative formula: Cumuldonsenjour= CALCULATE([Nombre de dons par jour];FILTER(ALL(DONS[Jcampagne]);DONS[Jcampagne]<=MAX(DONS[Jcampagne])))

Thank you!!

[Sean · Accepted solution]

Can you explain what exactly is not working?

Is the [Jcampagne] column of Data Type: Date

Also try filtering the table without referencing the column like this...

Cumuldonsenjour =
CALCULATE (
    [Nombre de dons par jour];
    FILTER ( ALL ( DONS ); DONS[Jcampagne] <= MAX ( DONS[Jcampagne] ) )
)

If DONS[Jcampagne] is a date and you've set a relationship to DATE[Date] then this should work also

Cumuldonsenjour =
CALCULATE (
    [Nombre de dons par jour];
    FILTER ( ALL ( DATE ); DATE[Date] <= MAX ( DATE[Date] ) )
)

[Pucca121]

Thank you so much, it works 🙂 

By the way, do you know how to calculate the cumulative return rate?

I did it like this: 

Taux de retour cumulé = DIVIDE([Cumul dons];SUM('Mailing details'[Nombre d'envois]))

Thank you again

:)))