Exponential Weighted Moving Average in power bi

Question

Hello, I am new to DAX and trying to calculate Exponential Weighted Moving Average for one of my report.
Please find below data element and expected result which I have calculated manually into excel and would like to replicate same logic to DAX so I can utilize into my Power BI report.
For very first month from selection it should use mean value for calculation as shown in below table and for all upcoming months calculated result value from previous month would be used instead of mean.

158246-sampledata.txt

Answer 1

Hi @Mayur ,

Thanks for your posting.

We are willing to help you, but your question is related to Power BI, please post your question in Microsoft Power BI Community that can let you get more helps. And I suggest that please provide more details about your question.

Best regards,
Carrin

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You can easily solve this with Column From Example. (Without calculating)
This solution is the same as Power BI;

For Excel;
https://support.microsoft.com/en-us/office/add-a-column-from-an-example-power-query-cd82c570-8da7-4d70-91a1-3827b5995eab

For Power BI;
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-example

Answer 3

Any aggregations in Power BI should be done using either variables or measures. The nomenclature for variables is VAR and then define your variable. The function will produce whatever follows the RETURN verb.

For this situation I suggest measures instead that are referenced by a variable, just in case you want to represent those on their own.