Forum Discussion
DAX Code for Previous Year Rolling Averages
I have read numerous posts on issues surround Rolling Averages, but I have not found one that answers my specific problem. I have a dashboard for the 2022 Fiscal Year. I need to write a formula t...
Is this what you are looking for?
| Start Date | Frame Count | Starts Avg R4M | Starts Avg R12M |
| 01/01/22 | 1 | 0.00 | 0.00 |
| 02/01/22 | 4 | 0.00 | 0.00 |
| 03/01/22 | 1 | 0.00 | 0.00 |
| 04/01/22 | 1 | 1.75 | 0.00 |
| 05/01/22 | 6 | 3.00 | 0.00 |
| 06/01/22 | 1 | 2.25 | 0.00 |
| 07/01/22 | 7 | 3.75 | 0.00 |
| 08/01/22 | 4 | 4.50 | 0.00 |
| 09/01/22 | 1 | 3.25 | 0.00 |
| 10/01/22 | 1 | 3.25 | 0.00 |
| 11/01/22 | 2 | 2.00 | 2.64 |
| 12/01/22 | 3 | 1.75 | 2.82 |
| 01/01/23 | 6 | 3.00 | 3.00 |
| 02/01/23 | 2 | 3.25 | 3.09 |
| 03/01/23 | 3 | 3.50 | 3.27 |
| 04/01/23 | 2 | 3.25 | 2.91 |
| 05/01/23 | 1 | 2.00 | 2.91 |
| 06/01/23 | 1 | 1.75 | 2.36 |
| 07/01/23 | 3 | 1.75 | 2.27 |
Hi HollyPludeTFA ,
Did Ashish_Mathur 's suggestions help with your scenario? If that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.
If that also doesn't help, please share more detailed information to help us clarify your scenario and test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Unfortunately the solution did not work. At this time, my client decided to simply remove the graphic from the dashboard.
Thank you! I appreciate the attention given to this issue.
Holly