Forum Discussion

OKgo's avatar
OKgo
Icon for Helper IV rankHelper IV
8 years ago
Solved

Moving average with respect to multple variables

I would like to add a column to this table that captures moving average with multiple variables. Once imported to powerbi, the date format is automatically detected/converted.     In Excel I...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi OKgo,

     

    Download the PowerBI desktop file from here.

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
8 years ago

My understand of moving average within Powerbi is that you need a date table and from there you could use the DATESINPERIOD function to get the MA over the disired time frame. I'm not sure if it will allow it where there is just a month value in place.