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.

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,

You may download my PBI file from here.

Hope this helps.

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

    thanks! that works. 

    Can 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's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      You are welcome.  In my measure, change the -11 to -5.

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

        Can we show the year 2022 when it is selected as a cumulative? I also want to show the last 6 months @Ashish_Mathur