Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@edwinderry try this measure
Measure = CALCULATE(AVERAGE('Table'[Value]),'Table'[Date]<=MAX('Table'[Date]))
@edwinderry try this measure
Measure = CALCULATE(AVERAGE('Table'[Value]),'Table'[Date]<=MAX('Table'[Date]))
Perfect, thank you 🙂
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |