cancel
Showing results for
Did you mean:
Member

Sum cumulative productions

Hello I want to find the cumulative production of one column, like this:

 Year Prouction Cummulative 1 5 5 2 80 85 3 14 94 4 56 70 5 78 134

How can I make the cummulative column?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Established Member

Re: Sum cumulative productions

Try this calculated Column:

```Calculated Column =
VAR PreviousRow =
TOPN (
1,
FILTER (
RUnn,
RUnn[Year] < EARLIER ( RUnn[Year] )

),
[Year], DESC
)
VAR PreviousValue =
MINX ( PreviousRow, [Production] )
RETURN
RUnn[Production] + PreviousValue```

*RUnn is my table name

Here is what I get:

Let me know if this works.

Thanks,

Tejaswi

2 REPLIES 2
Highlighted
Established Member

Re: Sum cumulative productions

Try this calculated Column:

```Calculated Column =
VAR PreviousRow =
TOPN (
1,
FILTER (
RUnn,
RUnn[Year] < EARLIER ( RUnn[Year] )

),
[Year], DESC
)
VAR PreviousValue =
MINX ( PreviousRow, [Production] )
RETURN
RUnn[Production] + PreviousValue```

*RUnn is my table name

Here is what I get:

Let me know if this works.

Thanks,

Tejaswi

Community Support Team

Re: Sum cumulative productions

Try this formula to create a measure

```Measure = var _prevalue=CALCULATE(SUM('Table'[Prouction]),FILTER(ALL('Table'),'Table'[Year]=MAX('Table'[Year])-1)) return
SUM('Table'[Prouction])+_prevalue```

Result:

Best Regards,

Lin

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

Announcements

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 3,896 guests
Recent signins: