cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## 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 01.05.2018 5 01.06.2018 5 01.07.2018 5

I am now looking for a measure or a calculated column.
I want the values from the "Value" column to be cumulated in the "Expected" column and everything grouped by month (The grouping by month makes power bi with table, not the measure or calculated columm)

 Date Value Expected 01.01.2018 15 15 01.02.2018 5 20 01.03.2018 5 25 01.04.2018 5 30 01.05.2018 5 35 01.06.2018 5 40 01.07.2018 5 45

I have tried so:

Cumulative =
VAR RowDate = Tabelle1[Date]
RETURN
CALCULATE (
SUM ( Tabelle1[Value] );
FILTER (
Tabelle1;
Tabelle1[Date] <= RowDate

)
)

Probably because the first of January occurs several times, in the origignal table.

Thank you for your help. Greetings from Switzerland.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III

## Re: Cumulated rows

@Blauezone

As a MEASURE,you could use

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

Try my new Power BI game Cross the River
4 REPLIES 4
Super User III

## Re: Cumulated rows

@Blauezone

As a MEASURE,you could use

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

Try my new Power BI game Cross the River
Super User III

## Re: Cumulated rows

@Blauezone

Your formula is also correct for calculated column

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

Try my new Power BI game Cross the River
Resident Rockstar

## Re: Cumulated rows

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.

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.
Regular Visitor

## Re: Cumulated rows

Wonderful, it works. Many thanks

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors