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 |
Ashish_Mathur
Super User
Super UserHi,
Please find attached the PBI file. DIY for 12 months based on my measure for 4 monts.
Hope this helps.