Forum Discussion
sonya7
Helper III
Helper III12 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
Ashish_Mathur
Super User
Super UserYou are welcome. In my measure, change the -11 to -5.
sonya7Helper III
Helper IIICan we show the year 2022 when it is selected as a cumulative? I also want to show the last 6 months @Ashish_Mathur
- Ashish_Mathur
Your question is not clear. Please clarify.
- sonya7
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_Mathur
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.
- sonya7
*
- Ashish_Mathur
Hi,
Someone else will help you.