Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Add Seasonality factor to future values

Hi All,    I have now a seasonality factor for 5 years from 2016 to 2020. I want to use these values to forecast in 2021.  First step is that I need to calculate the seasonality average of each mo...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    Hi Anonymous ,

    Ok，I see.

    Based on the pbix file I provided,change the first measure to the below:

    average seasonality = 
VAR test1 =
    SUMX (FILTER( ALL ( Data ),MONTH(Data[Date ])=month(MAX(dim_Calendar[Date]))), [Seasonality] )
VAR test2 =
    CALCULATE (YEAR( max( Data[Date ] ))-YEAR(MIN(Data[Date ])), ALL ( Data ) )+1
RETURN
    test1 /test2

    Final you will get the below:

     

    Wish it is helpful for you!

     

    Best Regards

    Lucien

v-luwang-msft's avatar
v-luwang-msft
Community Support
5 years ago

Hi Anonymous ，

I've tried it, but I'm not sure if it's what you're looking for, so you can see:

Step 1, according your data ,I get the average seasonality :

In my view, average seasonality=sum(2016 all years seasonality+2017 all years seasonality+2018 all years seasonality+2019 all years seasonality+2020 all years seasonality）/five years month (60)

average seasonality =
VAR test1 =
    SUMX ( ALL ( Data ), [Seasonality] )
VAR test2 =
    CALCULATE ( COUNT ( Data[Date ] ), ALL ( Data ) )
RETURN
    test1 / test2

Use in forecast ,if 2021 then use average seasonality:

NEW = IF([Seasonality]<>BLANK(),[Seasonality],[average seasonality])

 

 

Wish it is helpful  for you!

 

Best Regards

Lucien

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi lucien,

     

    i think we are almost there!!! 😄 I just have a doubt about the average seasonality calculation. The average seasonality for Jan 21 should be sum(Jan 16, Jan 17, Jan18 Jan 19 Jan 20) / 5 

     

    Then I think we are good!! Thanks so much again for your help 😊