Calculate accumulated measure value per month

[chrisgehm]

Hi everyone!

Some time ago I was told to aply this formula to get the accumulated value per month of a column:

AccumPerMonth = Calculate(Sum('table'[column]), Filter(All('table'[month]), table'[month]<=MAX(table'[month])))

Now, I've got 2 columns and a measure.
This measure gets the diference between those 2 tables.

So when I try to use the formular I've put before, I can't use the measure in the SUM statement.

Any idea why?

Kind regards

[v-huizhn-msft]

Hi @chrisgehm,

>>Now, I've got 2 columns and a measure. This measure gets the diference between those 2 tables.So when I try to use the formular I've put before, I can't use the measure in the SUM statement.

You have two tables, if there is relationship between them? And what are your two columns? Is there any chance to share your sample data for further analysis? I am unable to reproduce your scenario based on your description.

And why do not you use the formula? Could you please share your error message?

Best Regards,
Angelia

[chrisgehm · Accepted solution]

@v-huizhn-msft Hi! I could solve it by using a new column instead of a measure.

Kind regards