Reply
Member
Posts: 326
Registered: ‎12-04-2017

Previous Quarter

[ Edited ]

I have a table with survey results. I have calculated measures that counts the number of positive feedback, neutral feedback, negative back, and one measure that counts all of them together:

1.PNG

 

I've also created measures that calculates the percentage of each. The formulas are simply:

Positive Feedback/All Groups

Negative Feedback/All Groups

Nuetral Feedback/All Groups:

1.PNG

These measures are all calculating 2 years worth of data. What I'm trying to figure out is the average for the previous quarter for positive feedback. I constructed a formula that looks like this:

1.PNG

 

Which I assumed was a no brainer however, this formula for some reason is returning the exact same value as my overall Positive % rather than just the last quarter:

1.PNG

I know it is incorrect because if I take the survey dates and put them on a slicer and select only the dates that fall in the previous quarter, my positive % comes out to a different %:

1.PNG

 

So I know the percentage should be 65.62%. Any idea why the previous quarter function isn't working properly?

 

 

Highlighted
Anonymous
Posts: 0

Re: Previous Quarter

In the Last Quarter Satisfaction measure, maybe try using the while formula for [Positive %] instead of using the column as is.

Member
Posts: 326
Registered: ‎12-04-2017

Re: Previous Quarter

@Anonymous I'm not super positive what that is. I've gotten it working now but in the formula I'm just now hardcoding the year and the quarter to get myre results. While this works, I would have to go in and update this every quarter and when a new year arrives. Not a big deal but I don't want to accidentally forget to do so. Other measures and calculations rely on this one...