Forum Discussion

edwinderry's avatar
edwinderry
New Member
4 years ago
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 Val...
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    edwinderry  try this measure

    Measure = CALCULATE(AVERAGE('Table'[Value]),'Table'[Date]<=MAX('Table'[Date]))
smpa01's avatar
smpa01
Community Champion
4 years ago

edwinderry  try this measure

Measure = CALCULATE(AVERAGE('Table'[Value]),'Table'[Date]<=MAX('Table'[Date]))
edwinderry's avatar
edwinderry
New Member
4 years ago

Perfect, thank you 🙂