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

     

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi Blauezone,

 

I also agree with the measure formula provided by Zubair_Muhammad which should close your problem.

 

For you scenario, measure should be better than calculated column.

 

If you have solved you problem, only thing that you'll have to notice, just 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 feel free to ask.

 

Best Regards,

Cherry