Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |