Average over time

[edwinderry]

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.

[smpa01 · Accepted solution]

@edwinderry  try this measure

Measure = CALCULATE(AVERAGE('Table'[Value]),'Table'[Date]<=MAX('Table'[Date]))

[edwinderry]

Perfect, thank you 🙂