Greetings community,Please let me know if you have any ideas for me! I'm struggling with how to ignore an initial value.I have Income and Contributed Capital provided in the data. I need to separate out contributed change without the initial $1,000 included, then I need to combine Income + Contributed Change values. YearQuarterMonthIncomeContributed CapitalContributed ChangeCombined2021Q1Mar$200.00$1,000.00$0.00$200.002021Q2Jun$400.00$1,100.00$100.00$500.002021Q3Sep$100.00$1,100.00$0.00$100.002021Q4Dec$200.00$1,300.00$200.00$400.002022Q1Mar$200.00$1,300.00$0.00$200.002022Q2Jun$300.00$1,800.00$500.00$800.00

Hi sensemaker14 , I adjust something, please try below steps: 1. add a new column with below dax formula RK = VAR cur_year = [Year] VAR tmp = FILTER ( ALL ( 'Table' ), 'Table'[Year] = cur_year ) RETURN RANKX ( tmp, [Index],, ASC, DENSE ) 2. use this dax formula to replace above same name measure Adjust Contribute = VAR cur_rk = SELECTEDVALUE ( 'Table'[RK] ) VAR cur_year = SELECTEDVALUE ( 'Table'[Year] ) VAR cur__ct = CALCULATE ( MAX ( 'Table'[Contributed Capital] ), 'Table'[RK] = cur_rk && 'Table'[Year] = cur_year, ALL ( 'Table' ) ) VAR pre_ct = CALCULATE ( MAX ( 'Table'[Contributed Capital] ), 'Table'[RK] = cur_rk - 1 && 'Table'[Year] = cur_year, ALL ( 'Table' ) ) RETURN IF ( cur_rk = 1, 0, cur__ct - pre_ct ) 3. then you could get the output Please refer the attached .pbix file. Best regards,Community Support Team_ Binbin YuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

How do I pull out amt changed from cumulating sum while ignoring initial value?

Forum Discussion

Related content

Cumulative Total

Cumulative total all ignore specific filter help

Creating Cumulative Graphs

Year to date cumulative

Cumulative Total