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.
Hi All,
I have table, that has surveys since last 2 years. I would like to aggregate the NPS column based on date (Please note the surveys were answered on the same day). I need to show an upward arrow if the average NPS increased(greater than 0) from the latest survey as compared to the previous, downward arrow if its the opposite(the difference is less than 0).
How to add dynamic arrows depending on the measure value in Power BI - YouTube shows how to create the arrows. But I am finding difficulty in finding the difference in the average between the last two surveys.
Sample data below:
OCT 1 average NPS is 7.5.
APR 1 average NPS is 8.
So the NPS has increased.
I have the latest average using formula:
Solved! Go to Solution.
Hi @nrj1806,
This seems like a common multiple field date range analysis requirements, you can take a look at the following link about the start, end date range analysis.
Before You Post, Read This: start, end date
Regards,
Xiaoxin Sheng
Hi @nrj1806,
This seems like a common multiple field date range analysis requirements, you can take a look at the following link about the start, end date range analysis.
Before You Post, Read This: start, end date
Regards,
Xiaoxin Sheng
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 |
---|---|
108 | |
106 | |
87 | |
77 | |
69 |
User | Count |
---|---|
124 | |
112 | |
94 | |
84 | |
75 |