Forum Discussion
sensemaker14
3 years agoFrequent Visitor
How do I pull out amt changed from cumulating sum while ignoring initial value?
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...
- Anonymous3 years ago
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 Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ashish_Mathur
3 years agoSuper User
Do you also have Year and Month (as shown in the image of your post)) in the dataset?
sensemaker14
3 years agoFrequent Visitor
The date in my financial table is related to the date in my calendar table.
Let me know if that doesn't answer your question well enough.
- Ashish_Mathur3 years agoSuper User
Hi,
Share the download link of your PBI file. Do you want a measure or a calculated column?