Rolling 4 Quarter Average Quarter Over Quarter

[aguffin]

I've got three relevant columns of data, a date column and two integer columns. I need to calculate for every quarter a rolling 4 quarter average that's equal to the sum of one column of integers over the sum of the other.

To give a better example, please see the image here.

[v-danhe-msft]

Hi @aguffin,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft]

Hi @aguffin,

From your sample data in your posted picture, I wonder why the date you want to average is not in a quarter?

For example, the data in below picture belongs to 2015 Q1:

Could you please offer me more information about it?

Regars,

Daniel He

[aguffin]

Not sure what you mean, but I can introduce a step to group the data into quarters. Is that what you're talking about?

[v-danhe-msft · Accepted solution]

Hi @aguffin,

Could you mean you have the Quarter group? If so, you could refer to below steps:

Sample data:

Create below measure:

Measure = CALCULATE(SUM(Table1[Wrong Answers]),FILTER('Table1','Table1'[Quarter]=MAX('Table1'[Quarter])))/CALCULATE(SUM(Table1[Tests Taken]),FILTER('Table1','Table1'[Quarter]=MAX('Table1'[Quarter])))

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He