Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

accumulated column

Hello everyone. I have the following problem making a cumulative sum. First try to make a cumulative measure and everything works well using the following function: cumulative measure - CALCULA...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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:

no sumarizar.PNG

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.

columna calculada.PNG

I don't know where the problem might be. 😞

Thank you for taking the time to resolve my issue.

Best regards.

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

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.