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...
Hi HollyPludeTFA ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
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
