Forum Discussion

Pucca121's avatar
Pucca121
Helper II
9 years ago
Solved

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 () ...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    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] ) )
)

     

Sean's avatar
Sean
Community Champion
9 years ago

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's avatar
    Pucca121
    Helper II
    9 years ago

    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

     

    :)))