Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to create a Moving average in a combo chart in the desktop application.
I am new to Power BI and to DAX. I'm trying to create a new measure using these columns. I want to find the moving average as the time has progressed. Any help is greatly appreciated!!
Thanks!
Time
11/16/2015 11:29:23 PM |
11/17/2015 12:00:10 AM |
11/17/2015 1:00:44 AM |
11/17/2015 2:00:06 AM |
11/17/2015 6:00:06 AM |
11/17/2015 7:00:20 AM |
11/17/2015 8:00:02 AM |
11/17/2015 9:43:40 AM |
11/17/2015 10:00:19 AM |
11/17/2015 11:00:00 AM |
11/17/2015 12:00:13 PM |
11/17/2015 1:01:38 PM |
11/17/2015 2:00:36 PM |
Total Avg
564 |
492 |
452 |
507 |
547 |
580 |
601 |
628 |
599 |
535 |
478 |
532 |
570 |
I would start here:
http://www.daxpatterns.com/time-patterns/
Has some examples of moving totals, etc.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |