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.

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

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's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi OKgo,

 

If my reply helped, please mark it as Answer.