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

     

Blauezone's avatar
Blauezone
Regular Visitor
8 years ago

Wonderful, it works. Many thanks