Forum Discussion
Month on Month - % difference
Perhaps i didn't explain well. [Post Count] wasn't supposed to be a field but an example of a measure. What you need to do is a create a measure that performs your KPI, knowing that it doesn't handle the correct time constraint. The calculate statement will run your measure and force in your applicable dates.
You will notice in my example I created the measure Post Count, which does a count of the number of rows in the data set. The expectation here, for my example, was that each post would be a single row in the data. Thus if I was to count my pretend data, i could get a count of all the posts in a given time period.
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.