cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Calculation of average

Hi Dear Power Bi expert,

I need help to calculate an average.

I want to create a column which calculate cost average per month in the same table.

In front of each cost, I need to put the cost month average (in a new column)

Many thanks

Best regards

Wilfried

2 ACCEPTED SOLUTIONS
Super User

@Anonymous ,

try this

``````Sales Avg =
var _Sales = CALCULATE( AVERAGEX(financials,financials[ Sales]),ALLEXCEPT(financials,financials[Month Year]))
return _Sales``````

Thanks,

Arul

If I answered your question then mark my post as a solution and a kudo would be appreciated.
Community Champion

@Anonymous it's really hard to say what you want with the data supplied 🙂 but I'll take a guess that you have one table with both columns and you need something like this:

``````'Table'[New_Column] =
CALCULATE (AVERAGE('Table'[Cost]), ALLEXCEPT('Table', 'Table'[Month]))``````

Showcase Report – Contoso By SpartaBI

2 REPLIES 2
Community Champion

@Anonymous it's really hard to say what you want with the data supplied 🙂 but I'll take a guess that you have one table with both columns and you need something like this:

``````'Table'[New_Column] =
CALCULATE (AVERAGE('Table'[Cost]), ALLEXCEPT('Table', 'Table'[Month]))``````

Showcase Report – Contoso By SpartaBI

Super User

@Anonymous ,

try this

``````Sales Avg =
var _Sales = CALCULATE( AVERAGEX(financials,financials[ Sales]),ALLEXCEPT(financials,financials[Month Year]))
return _Sales``````

Thanks,

Arul

If I answered your question then mark my post as a solution and a kudo would be appreciated.

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors