Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Previous Quarter

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:

 

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:

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:

 

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:

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 %:

 

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

 

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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...