Reply
Frequent Visitor
Posts: 3
Registered: ‎11-03-2016

Cumulative sum not showing for some columns and showing for others columns

 

Hello everyone!

 

Screen Shot 2018-10-20 at 15.59.17.jpg

As seen above, the cumulative sum is not showing for these 2 columns...

I'm getting crazy trying to find out what's wrong...

The formula is taken from Mr Marco Russo...

Please, help me!!

Thank you

Super User
Posts: 2,392
Registered: ‎09-19-2016

Re: Cumulative sum not showing for some columns and showing for others columns

Hi @bihumano,

 

Why are you using the IF statement? 

 

You should try to use only the second part of your formula without the IF.

 

Regards,

MFelix

 

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Frequent Visitor
Posts: 3
Registered: ‎11-03-2016

Re: Cumulative sum not showing for some columns and showing for others columns

@MFelix,

As you can see, the result is the same for the following formula

Realizado Acumulado = 
CALCULATE (
    SUM ( vwConsolidado[ValorRealizado] );
    FILTER (
        ALL (Dates );
       Dates[Date] <= MAX ( Dates[Date] )
    )
)

Screen Shot 2018-10-20 at 17.38.24.jpg

Super User
Posts: 2,392
Registered: ‎09-19-2016

Re: Cumulative sum not showing for some columns and showing for others columns

Hi @bihumano,

 

Try to use the following formula:

 

Realizado Acumulado = 
CALCULATE (
    SUM ( vwConsolidado[ValorRealizado] );
    FILTER (
        ALL (vwConsolidado[Data] );
       vwConsolidado[Data] <= MAX ( Dates[Date] )
    )
)

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Highlighted
Community Support Team
Posts: 3,195
Registered: ‎02-06-2018

Re: Cumulative sum not showing for some columns and showing for others columns

Hi @bihumano,

 

Have you solved your problem?

 

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please share some data sample which could reproduce your scenario and your desired output so that we could help further on it.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.