Forum Discussion

Blauezone's avatar
Blauezone
Regular Visitor
8 years ago
Solved

Cumulated rows

Hi everyone, I'm new in the forum. Here's my problem. I have this chart.   Date Value 01.01.2018 5 01.01.2018 5 01.01.2018 5 01.02.2018 5 01.03.2018 5 01.04.2018 5 0...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Blauezone

     

    As a MEASURE,you could use

     

    Cumulative =
CALCULATE (
    SUM ( Tabelle1[Value] ),
    FILTER ( ALL ( Tabelle1 ), Tabelle1[Date] <= MAX ( Tabelle1[Date] ) )
)

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Blauezone

 

As a MEASURE,you could use

 

Cumulative =
CALCULATE (
    SUM ( Tabelle1[Value] ),
    FILTER ( ALL ( Tabelle1 ), Tabelle1[Date] <= MAX ( Tabelle1[Date] ) )
)

 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Blauezone

 

Your formula is also correct for calculated column

 

But you should choose "don't summarize" instead of deafult "SUM" of the field