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 ,

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