Weighted moving average

[Silvia_Gulu_BXL]

Hello, I have a table with the demand per month:

I want to calculate the moving average but with weighted average like below:

Forecasted_demand=(M1*1+M2*2+M3*3)/6

(M1: 3 months ago, M2: 2 months ago, M3: previous month)

Could you help to write the DAX measure to get it?

Thank you in advance!

Kind regards,

Silvia

[Daniel29195 · Accepted solution]

Hello @Silvia_Gulu_BXL 

output : 

kindly use the following measure : 

moving weighted average =

 var current_month =  max(Table30[date])

 var M3 =  

 CALCULATE(

    SUM(Table30[actual demand]),

    Table30[date] = EDATE(current_month,-1)

 )

var M2 =

 CALCULATE(

    SUM(Table30[actual demand]),

    Table30[date] = EDATE(current_month,-2)

 )

var M1 =

 CALCULATE(

    SUM(Table30[actual demand]),

    Table30[date] = EDATE(current_month,-3)

 )

var resl = ( (M3*3) +  (M2*2) + (M1*1)) / 6

RETURN resl

 

 let me know if this works for you . 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠

[Silvia_Gulu_BXL]

@Daniel29195 Many thanks for the solution! I have marked it as "accepted".