Forum Discussion

bryanang's avatar
bryanang
Frequent Visitor
3 years ago

How to Calculate Rolling Average?

I have a dataset with a date column, column called "column" (every value is 1 for simplicity), and a measure for rolling average.   Rolling average = CALCULATE(    SUM(        vw_BI_Yield_Tren...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Share the download link of the PBI file and shwo the expected result.

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

    That takes me to a sign-in page.

    • bryanang's avatar
      bryanang
      Frequent Visitor
      3 years ago

      Yeap its uploaded to the power bi service, would need you to log in with an account.

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

        I obviously cannot log in there.  Share the download link of the PBI file.

    • bryanang's avatar
      bryanang
      Frequent Visitor
      3 years ago

      Seems like I cannot share with you because you're outside of the organisation, im sorry. But it seems like the issue could be because I have duplicate rows in my date. (Have filtered it down in the data view tab but didn't know that the filter gets stripped off in the report view)