Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have Data in a table that looks like this:
It's feedback from a survey and I've created measures that counts each type of category by person. I've also created a measure to get the percentages of each type as well. Positive for instance looks like this:
Which works as intended. This calcuation is for the overall feedback which is two years worth of data. What I'm trying to figure out is how to do the same thing but for the previous Quarter (Jan-Mar). I created a measure that looks like this:
But for some reason this is giving me the same numbers as the overall satisfaction % numbers:
I've used this DATEADD formula with other measures to get first quarter results so I'm not sure why it's not working here. Any thoughts?
@Anonymous,
Have you added Date field as shown in the following similar screenshot?
Regards,
Lydia
Hi @Anonymous
Try the function PREVIOUSQUARTER()
Hope it works.
@Anonymous Tried it. Still gives the same results...
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |