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...
Xiaoxin,
Thank you - I am scrubbing a subset of data and will upload it to a pbix and share.
Holly
https://drive.google.com/file/d/1fS5OnXZGRuRkqIR3X46qT_wejblmrdLY/view?usp=drive_link
This is a link to my pbix.
Holly
- Ashish_Mathur
Super User
Access 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.
