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,
I’m very new to DAX so would appreciate any help on this one!
I have Overall Satisfaction data measured on a scale of 1 (Very dissatisfied) to 7 (Very satisfied). I have bucketed this data by creating a a separate measure for 3 groups: T2B (scores 6&7); M3B (scores 3to5) and B2B (scores 1&2), where the measures are percentages of the total base.
The results for the 3 groups are shown over a 6-month period:
I want to smooth out the trendlines using a 3-month rolling average. I can create an overall 3-month rolling average based on the actual Overall Satisfaction score but I can’t figure out how to do it based on percentages for each group. Or perhaps there's a different way of calculating the rolling average for percentages? Many thanks!
@Anonymous ,
You may research the code generated by Quick measure Rolling average.
Thanks for the suggestion about using a Quick Measure. I had tried that but got an error message 'Only Power BI - provided date hierarchies are supported' (although, using the same Date field in a Month over Month change measure worked.
I found the following syntax on another discussion thread:
OVERALL CSAT AVG_3MTH_MA =
CALCULATE (
AVERAGEX ( 'testdata', 'testdata'[Overall Sat] ),
DATESINPERIOD (
'DateKey'[Date],
LASTDATE ( 'DateKey'[Date] ),
-3,
MONTH
)
)
I've used this successfully to create a rolling 3-month average for the score but I can't create the rolling average for the percentage buckets (as described in my first post) correctly. I'm not sure of the syntax I should be using to filter the scores for each bucket.
I'd really appreciate any help on this one! TIA.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |