Forum Discussion
Solved
Average over time
Hi,
I'm trying to plot the average of some values over time. It's a very simple set of data, see screenshots from Excel below. I want produce the equivalent chart in Power BI, using the Date and Value columns. The Cumulative Average column is the calculated value I have used in Excel just as an example. Thanks.
edwinderry try this measure
Measure = CALCULATE(AVERAGE('Table'[Value]),'Table'[Date]<=MAX('Table'[Date]))
2 Replies
edwinderry try this measure
Measure = CALCULATE(AVERAGE('Table'[Value]),'Table'[Date]<=MAX('Table'[Date]))Perfect, thank you 🙂
