Need a measure to average across four months of data in PBI

[Gameplayer13905]

Hello and thank you in advance. Please see the images below. I have a table with a customer name column and four months of revenue data on it. I need to average the rows in the table below in a column to the right of the "Sep-2023" column

This is the error I'm getting and as this is my first measure I don't really know what I'm doing

These are the firld name column headers and the table is called v_relevelgroupingcode

What have I got wrong and how do I link the measure to a new column for the average of rows?

Thanks again

[Anonymous · Accepted solution]

Hi @Gameplayer13905 ,

Below is my table:

The following DAX might work for you:

Measure = 
   AVERAGEX(
   v_relevelgroupingcode , 
   (v_relevelgroupingcode[Jun-2023] + v_relevelgroupingcode[Jul-2023] + v_relevelgroupingcode[Aug-2023] + v_relevelgroupingcode[Sep-2023])/4
   )

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gameplayer13905]

Wow, thank you Xianda, that actually worked!!! I am marking this as solved. Thank you again! I was close but not quite there