Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
OscarSuarez10
Helper III
Helper III

Sum cumulative productions

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

 

YearProuctionCummulative
155
28085
31494
45670
578134

 

How can I make the cummulative column?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @OscarSuarez10 ,

 

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:

Capture2.PNG

 

Let me know if this works.

 

Thanks,

Tejaswi

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi, @OscarSuarez10 

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:

7.JPG

 

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.
Anonymous
Not applicable

Hi @OscarSuarez10 ,

 

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:

Capture2.PNG

 

Let me know if this works.

 

Thanks,

Tejaswi

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.