Forum Discussion
Cumulative total
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!!
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] ) ) )
2 Replies
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] ) ) )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
:)))
