Forum Discussion
Calculating Average question
Hi everyone, I am new to power bi and I am starting a report where the source file is a basic excel file. I have created a matrix and added the data I needed it, please see the attached. My chal...
DaniyalKhaleel1
Resolver II
Resolver IIYes,Use a DAX measure rather than Power Query.
Average 2023-2026 =
AVERAGEX(
VALUES('Table'[Year]),
CALCULATE(SUM('Table'[Value]))
)
This will calculate the average dynamically based on the selected years/filters.
Recommendation Use Power Query for data transformation and DAX measures for calculations like averages, totals, percentages, etc.