Average a score for the most current month (MAXMONTH)

[paulsmit]

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

[v-piga-msft · Accepted 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

[paulsmit]

Thank you Cherry.

Much appreciated