Moving average with respect to multple variables

[OKgo]

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 was previously using a pivot table and an AVERAGE formula pointing at the correct cells. Tips how I could elegantly do this in DAX would be appreaciated.

[Ashish_Mathur]

Hi @OKgo,

You may refer to my solution here.

Hope this helps.

[OKgo]

Hi Ashishi

That is really impressive. I opend up the developer section within Excel and can see the VBA objects you created. I was hoping that within PowerBi I could use the 'add column' feature and have something a DAX statement in that extra column. Reason being although I personally have Excel 2013 the clients that I am working with do not.  I am deploying the data via a PowerBi web-app. Would there be a way I could convert your exceptional solution to a PowerBi 'add column' sort of solution? 

Thank you so much!

[Ashish_Mathur]

Hi @OKgo,

You are mistaken.  There is no VBA in there.  Mine's an out and out DAX solution.

[OKgo]

Dear Ashish,

OK I don't have PowerPivot. I will work on getting a licence in the coming days.

Can you please paste the DAX code here? I am hoping to open PowerBi. Add Custom Column. Paste / edit the DAX code. And have that helper column as per your solution in my data set.

Thank you so much. I am really looking forward to learning DAX! I suppose I have to start somewhere.

[Ashish_Mathur]

Hi @OKgo,

If my reply helped, please mark it as Answer.

[Ashish_Mathur · Accepted solution]

Hi @OKgo,

Download the PowerBI desktop file from here.

[davehus]

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.