Forum Discussion

JonathanJohns's avatar
JonathanJohns
Helper III
9 years ago

Running Average for three weeks

Good afternoon,   I have a problem to do a formula with Power BI Desktop. I had a look on the forum to find my answer but I was not able to do the operation.   I have a table like this one with d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi JonathanJohns,

Do you create newtable using the first formula? And do you right click the newTable and select "New Column" to apply the third formula?

Thanks,
Lydia Zhang

JonathanJohns's avatar
JonathanJohns
Helper III
9 years ago

I have done like you said. I created a new table with the DAX, then created the colum"Index" and finally the column "Running Average" and I got the last table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi JonathanJohns,

    The formulas work as expected in my scenario, could you please share me all the data in  your original table so that I can  test?



    Thanks,
    Lydia Zhang

    • JonathanJohns's avatar
      JonathanJohns
      Helper III
      9 years ago

      How can I do to send you my data please ?

      • JonathanJohns's avatar
        JonathanJohns
        Helper III
        9 years ago

        I finally did it ! It was just a little error in the DAX. I get the table I want.

         

        Thanks for your help.