Forum Discussion
sonya7
3 years agoHelper III
12 month rolling average
I have Amount data based on Startdate date. How can I write the 12-month average? i'm new, it is important to me that you are clear 🙏 thanks
- 3 years ago
Ashish_Mathur
3 years agoSuper User
Your question is not clear. Please clarify.
sonya7
3 years agoHelper III
hi ashish,
i want to see your 12 month average cumulative every year. I also want to show the last 6 months while doing this
- Ashish_Mathur3 years agoSuper User
I still do not understand your requirement. Show the expected result very clearly in an MS Excel file with formulas. I will try to convert those Excel formulas into DAX formulas.
- sonya73 years agoHelper III
*
- Ashish_Mathur3 years agoSuper User
Hi,
Someone else will help you.