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)
Go to Solution.
Sales Avg =
var _Sales = CALCULATE( AVERAGEX(financials,financials[ Sales]),ALLEXCEPT(financials,financials[Month Year]))
View solution in original post
@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:
CALCULATE (AVERAGE('Table'[Cost]), ALLEXCEPT('Table', 'Table'[Month]))
Showcase Report – Contoso By SpartaBI
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!