06-15-2018 06:31 AM - edited 06-15-2018 06:32 AM
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?
06-15-2018 07:52 AM
@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...