Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

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

Anonymous ,

try this

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

Thanks,

Arul

SpartaBI
4 years ago
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

Super User

Anonymous ,

try this

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

Thanks,

Arul

SpartaBI
Community Champion
4 years ago
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