Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello, I am new to DAX and trying to calculate Exponential Weighted Moving Average for one of my report.
Please find below attached 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.
| Row Labels(A) | Percent Meeting(B) | Count | Sum | Mean(F) | Par1(G) | Par2(H) | Result(I) | Formula | |
| 7/1/2017 | 0.52303989 | 9 | 4.215079105 | 0.46834 | 0.2 | 0.8 | 0.479281676 | (G2*B2)+(H2*F2) | |
| 8/1/2017 | 0.453555986 | 0.2 | 0.8 | 0.474136538 | (G3*B3)+(H3*I2) | ||||
| 9/1/2017 | 0.442665891 | 0.2 | 0.8 | 0.467842409 | (G4*B4)+(H4*I3) | ||||
| 10/1/2017 | 0 | 0.2 | 0.8 | 0.374273927 | (G5*B5)+(H5*I4) | ||||
| 11/1/2017 | 0.75 | 0.2 | 0.8 | 0.449419142 | (G6*B6)+(H6*I5) | ||||
| 12/1/2017 | 0 | 0.2 | 0.8 | 0.359535313 | (G7*B7)+(H7*I6) | ||||
| 1/1/2018 | 0.411053307 | 0.2 | 0.8 | 0.369838912 | (G8*B8)+(H8*I7) | ||||
| 2/1/2018 | 0.914832191 | 0.2 | 0.8 | 0.478837568 | (G9*B9)+(H9*I8) | ||||
| 3/1/2018 | 0.719931841 | 0.2 | 0.8 | 0.527056422 | (G10*B10)+(H10*I9) |
My comment on this blog post may be useful to you:
https://community.powerbi.com/t5/Community-Blog/Exponential-Moving-Average-in-Power-Query-EMA/ba-p/1...
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |