Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
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
Arul
Super User
Super User

@Anonymous ,

try this

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

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


View solution in original post

SpartaBI
Community Champion
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]))

 

 


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

View solution in original post

2 REPLIES 2
SpartaBI
Community Champion
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]))

 

 


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

Arul
Super User
Super User

@Anonymous ,

try this

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

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.