Forum Discussion

Rickstor's avatar
Rickstor
Frequent Visitor
3 years ago
Solved

Moving Average 5 periods

Hello. Please help me. I need a moving average, 5 periods, in Power BI, using a measure. This is so easy in Microsoft Excel. I need this:   The column 'year' has a text format.   After se...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

    5 step 3 = 
VAR _CurentRx = MAX('data'[Rx])
VAR _Results = CALCULATE(SUM(data[value]), FILTER(ALL(data),'data'[Rx]<=_CurentRx&&'data'[Rx]>=_CurentRx-4), VALUES(data[cod_region])) /5
RETURN
IF(_CurentRx< 6 , BLANK(),_Results)
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

What do the numbers in the SE column represent?  Are they week numbers?  If yes, then if you have a Calendar Table with week numbers as well, there is a fairly straight forward solution.

  • Rickstor's avatar
    Rickstor
    Frequent Visitor
    3 years ago

    Yes, they are week numbers. Like this:

    It's a epidemiological calendar. 
    Maybe can I use the column "End", using relationship between column 'SE' and my other dataset?

    • Rickstor's avatar
      Rickstor
      Frequent Visitor
      3 years ago

      my previous post, that is a problem, I don't have the epidemiological calendar from years 2022 and 2021. In my project, I only need 2023 calendar.

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

      Hi,

      Share the download link of the MS Excel file.