Forum Discussion
accumulated column
Community SupportHi, Anonymous
It’s my pleasure to answer for you.
According to your description, It seems that the result of your measure is correct, while calculated column is incorrect. You can try this in the format of the calculated column to prevent it from being aggregated.
Or you can try allselected in your calculated column.
Like this:
cumulative column =
CALCULATE (
SUM ( Sheet1[Amount] ),
FILTER ( ALLSELECTED ( Sheet1 ), Sheet1[Date] < - EARLIER ( Sheet1[Date] ) )
)If the problem isn’t solved, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @v-janeyg-msft
I was reviewing your solution, but keep mis-calculating. First, I do not get the option not to summarize the data, adjunot image:
Also, using the sign function still occurs the same problem. From what you see in the data, it may be when you change the year that you do not take the data correctly.
I don't know where the problem might be. 😞
Thank you for taking the time to resolve my issue.
Best regards.
- v-janeyg-msft
Hi, Anonymous
You may be a little confused about the concept of measure and column. The accumulation of column will be calculated for each date in the original table. If it is placed in the visual with years and months,the value of sum will be aggregated multiple times, resulting in a larger result. You can try with the original table's date .
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.