Forum Discussion

as3znaus's avatar
as3znaus
Helper I
9 years ago
Solved

Cumulative SUM by CODE

Hi Everyone,   How can I create a "Coste Actual Estimado" column that shows an accumulated value, something like this:     Coste Mensual Estimado Coste Total 2015 Coste Actual Estimado M...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi as3znaus,

     

    Based on the sample data above, you can create "Coste Actual Estimado" column using below formula. But, you should add an index column in Query Editor.

     

    Coste Actual Estimado =
CALCULATE (
    SUM ( 'Cumulative SUM'[Coste Mensual Estimado] ),
    FILTER (
        'Cumulative SUM',
        'Cumulative SUM'[Index] <= EARLIER ( 'Cumulative SUM'[Index] )
    )
)
    + 'Cumulative SUM'[Coste Total 2015]

     

    What do you mean "disinguish the values by CODE"? Is "CODE" a column in your source table? For further analysis, would you please share some more sample data and describe more detailed about "CODE"?

     

    Thanks,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi as3znaus,

 

Based on the sample data above, you can create "Coste Actual Estimado" column using below formula. But, you should add an index column in Query Editor.

 

Coste Actual Estimado =
CALCULATE (
    SUM ( 'Cumulative SUM'[Coste Mensual Estimado] ),
    FILTER (
        'Cumulative SUM',
        'Cumulative SUM'[Index] <= EARLIER ( 'Cumulative SUM'[Index] )
    )
)
    + 'Cumulative SUM'[Coste Total 2015]

 

What do you mean "disinguish the values by CODE"? Is "CODE" a column in your source table? For further analysis, would you please share some more sample data and describe more detailed about "CODE"?

 

Thanks,
Yuliana Gu