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 know this has been somewhat asked but what I'm trying to do has a slightly different presentaion and I'm having a hard time figuring out how to create a rolling average.
Below is a sample of how my data is presented.
DATE THING VALUE
1/1/2018 | A | 1 |
1/1/2018 | B | 7 |
1/1/2018 | C | 3 |
1/2/2018 | A | 4 |
1/2/2018 | B | 4 |
1/2/2018 | C | 2 |
1/3/2018 | A | 1 |
1/3/2018 | B | 8 |
1/3/2018 | C | 2 |
1/4/2018 | A | 3 |
1/4/2018 | B | 10 |
1/4/2018 | C | 10 |
1/5/2018 | A | 2 |
1/5/2018 | B | 3 |
1/5/2018 | C | 7 |
What I'm trying to do is, have another column to the right of VALUE that shows the average VALUE for each thing over the last number of days (15 or 30 for example).
Thanks in advance for the help
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 |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |