Forum Discussion

sonya7's avatar
sonya7
Icon for Helper III rankHelper III
3 years ago
Solved

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
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

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's avatar
sonya7
Icon for Helper III rankHelper III
3 years ago

*

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Someone else will help you.