Problem with Cumulative sum

[Anonymous]

Hi,

I am trying to use cumulative sum but I am not getting any results.  I select a year and a month and the fields with the formula  appear blank. I have values for all the fields..Can you help?

I have two formulas

cumulative sum=

CALCULATE (

SUM ( vwExecucaoMensalItem[BudgetPurchaseValue] );

FILTER (

ALL (vwExecucaoMensalItem[Date] );

vwExecucaoMensalItem[Date] < MAX ( vwExecucaoMensalItem[Date])

)

)

cumulative sum 2=

CALCULATE (

SUM ( vwExecucaoMensalItem[BudgetPurchaseValue] );

FILTER (

ALL (vwExecucaoMensalItem[Date] );

vwExecucaoMensalItem[Date] >MAX ( vwExecucaoMensalItem[Date])

)

)

[Mariusz]

Hi @Anonymous 

Try the below.

cumulative sum=
CALCULATE (
    SUM ( vwExecucaoMensalItem[BudgetPurchaseValue] );
    FILTER (
        ALL ( vwExecucaoMensalItem );
        vwExecucaoMensalItem[Date] <= MAX ( vwExecucaoMensalItem[Date])
    )
)

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I already try but it doesn't give the right results... 😕

[Anonymous]

Hi @Anonymous ,

If you can please share a pbix file with some sample data for test. It is hard to test without any detail information.

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Thank you but I already solve it. I had to create a date table in order to work.