Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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