Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to Solution.
@Anonymous ,
try this
Sales Avg =
var _Sales = CALCULATE( AVERAGEX(financials,financials[ Sales]),ALLEXCEPT(financials,financials[Month Year]))
return _Sales
Thanks,
Arul
@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]))
@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]))
@Anonymous ,
try this
Sales Avg =
var _Sales = CALCULATE( AVERAGEX(financials,financials[ Sales]),ALLEXCEPT(financials,financials[Month Year]))
return _Sales
Thanks,
Arul
User | Count |
---|---|
134 | |
68 | |
67 | |
54 | |
52 |
User | Count |
---|---|
207 | |
95 | |
64 | |
61 | |
57 |