Forum Discussion
Month on Month - % difference
Hi Anonymous
Ok, I think I understand a little better now
That being said, I'm still having trouble getting a formula to work...
I've created a column for 'average engagement rate' (=AVERAGE('POST DATA[ENGAGEMENT RATE]) ) and then have tried to apply the calculate statement to this but it still doesn't recognise it as a Measure.
Ideally, I'm wanting the average engagement rate for the current month vs the previous
Thanks again, and sorry for all the confusion
Sonia
I noticed you said that you created a column for your Average. That might be the problem. A Measure and a Column are not the same things, although their buttons are next to each other. Try recreating that formula as a measure rather than a column
Oh, great! yeah, i was usually a new column instead. I've now created the Average engagement as a Measure and was able to add it into the formula, but now I'm getting a 'circular dependency' error :(
Am I using the right comulm from my Date table (DateKey)?
Thanks again for all of your help
From afar this will be harder to diagnose, but you'll need to have a look at the 2 columns mentioned in the error. Its likely this formula isn't the problem but is highlighting another issue.