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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi OKgo,

 

You may refer to my solution here.

 

Hope this helps.

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

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

    Hi OKgo,

     

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

    • 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,

         

        Download the PowerBI desktop file from here.