Previous Quarter Average

Question

Given this data:&nbsp;How can I write DAX that will give me the average of these 3 retention numbers? I know the number should come out to 85.16 but in my attempt to calculate this, I'm getting this which is just the last number of the previous quarter:

danb · Answer

AnonymousI might be misunderstanding the issue but if you are selecting the year and months can't you just take a simple average in a measure?&nbsp;Last Quarter Retention = AVERAGE(Table1[Retention])&nbsp;This returns 85.16.&nbsp;

anonymous · Answer

danb&nbsp;I was showing the month and year for demonstration purposes. On the actual page I'm using this for, I do not have these slicers so I'm trying to figure out how to calculate it through DAX.

danb · Answer

Anonymous&nbsp;Can you upload a view of your current table you are working with?

anonymous · Answer

danb&nbsp;Sure thing:&nbsp;&nbsp;So in table 1, that is simply the overall retention. Table 2 is supposed to be calculating the retention for the 1st quarter. As you can see, It isn't taking the average of what Jan-Mar is, it's just returning what the value was for the final month of quarter 1. This holds true for any employee I try to toggle, so something isn't working right.

danb · Answer

Anonymous&nbsp;- so you have slicers for each "EMS AM". Are there any other slicers you have for the user?

Forum Discussion

Previous Quarter Average

6 Replies

Related content

How to get previous quarter's previous quarter data?

Average of Previous Quarter Values

Previous Quarter Comparison

Dax Help! Average Volume Previous Quarter and Previous Month - Relative, and Partial Periods!

Previous Quarter