Forum Discussion

ErickReiis's avatar
ErickReiis
Icon for Helper I rankHelper I
3 years ago
Solved

Accumulated by adding value from previous years

Hello everyone, everything good? I have a table where I need to perform a sum of information from the previous year with the current year to generate a kind of accumulated to perform a rate calculat...
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, ErickReiis 

     

    You can try the following methods.

    Measure = CALCULATE ( SUM ( 'Table'[Value] ),
    FILTER ( ALL ( 'Table' ),
        [Type] = SELECTEDVALUE ( 'Table'[Type] )
            && [Year] <= SELECTEDVALUE ( 'Table'[Year] )
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, ErickReiis 

 

You can try the following methods.

Measure = CALCULATE ( SUM ( 'Table'[Value] ),
    FILTER ( ALL ( 'Table' ),
        [Type] = SELECTEDVALUE ( 'Table'[Type] )
            && [Year] <= SELECTEDVALUE ( 'Table'[Year] )
    )
)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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