Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |