Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Rolling Average within Groups in Power Query Help

Hi! I'm trying to figure out how to add a column which will compute a rolling N month average within groups in M.   For example, I would like to have something similar to this table:   Grou...
Need Help
  • Seward12533's avatar
    Seward12533
    8 years ago

    Dont' forget PowerPivot in Excel where you have the same PowerQuery [M] and DAX resources within PowerBI. But you can put results in a table on a sheet and then run wild with macros. Not sure if the R integration will help you in PowerBI but you might look into that and from the recent MS BI Summit I learned that soon you will be able to use python scripts which will open up all kinds of options in PowerBI.

     

    If you don't see PowerPivot in excel menus you just need to enable it assuming you using Pro or other version that includes powerpivot. Tip - Its a COM add in.

Seward12533's avatar
Seward12533
Icon for Solution Sage rankSolution Sage
8 years ago

Not sure about the "M" solution but can clarify what you need to in M in the subsequent steps that you can't do in DAX?   Using DAX you can build quite complicated tables you can then link to and use in your model.