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.
Morning everyone,
I'm pretty new to Power BI and i've been tasked with creating a Customer Satisfaction dashboard. I'm enjoying working with the software having previously used Qlikview.
What i'm attempting to do is have a card displayed on my dashboard that shows the average satisfaction score for my most recent month. In Qlikview I would have used some set analyis to solve this issue but i'm struggling to replicate the syntax in Power BI.
Any help would be much appreciated.
Cheers
Paul
Solved! Go to Solution.
Hi @paulsmit,
It seems that you want to calculate the average value for the max month.
We usually use Average fucntion in power bi to calculate the average value.
Here is my example. If you want to get the average of the max month, you could create the measure with the formula below.
average_amount for the max_month = CALCULATE ( AVERAGE ( 'Table'[Amount] ), FILTER ( 'Table', MONTH ( 'Table'[Date] ) = MONTH ( MAX ( 'Table'[Date] ) ) ) )
If you still need help, please share some data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
Hi @paulsmit,
It seems that you want to calculate the average value for the max month.
We usually use Average fucntion in power bi to calculate the average value.
Here is my example. If you want to get the average of the max month, you could create the measure with the formula below.
average_amount for the max_month = CALCULATE ( AVERAGE ( 'Table'[Amount] ), FILTER ( 'Table', MONTH ( 'Table'[Date] ) = MONTH ( MAX ( 'Table'[Date] ) ) ) )
If you still need help, please share some data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
Thank you Cherry.
Much appreciated
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |