Forum Discussion
DAX Code for Previous Year Rolling Averages
Super UserAccess Denied message. Share data in a format that can be pasted in an MS Excel file and show the expected result.
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 |
- Ashish_Mathur
Hi,
Please find attached the PBI file. DIY for 12 months based on my measure for 4 monts.
Hope this helps.
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