Reply
Highlighted
Frequent Visitor
Posts: 6
Registered: ‎12-12-2018
Accepted Solution

Average a score for the most current month (MAXMONTH)

[ Edited ]

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


Accepted Solutions
Community Support Team
Posts: 2,926
Registered: ‎02-06-2018

Re: Average a score for the most current month (MAXMONTH)

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] ) ) )
)

 

average for max_month.PNG

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 2,926
Registered: ‎02-06-2018

Re: Average a score for the most current month (MAXMONTH)

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] ) ) )
)

 

average for max_month.PNG

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 6
Registered: ‎12-12-2018

Re: Average a score for the most current month (MAXMONTH)

Thank you Cherry.

 

Much appreciated Smiley Happy