Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Seasonality Factor

Hi all, 

 

I would like to calculate seasonality using a measure but i am unsure of how to do it. I have a date table and also a data table containing revenue.See below of the measure that i am trying to achieve: 

 

Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Please check if this is what you want:

    Seasonality Factor = 
VAR DayAvg_ =
    CALCULATE ( AVERAGE ( Data[revenue] ), ALLEXCEPT ( 'Date', 'Date'[Year],'Date'[Day] ) )
VAR DaybyMonth_ =
    SUM ( Data[revenue] )
RETURN
    DIVIDE ( DaybyMonth_, DayAvg_ )

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try a measure like

    Assume you have measure, a new measure

    divide([measure],calculate([measure], filter(all(Date), Date[Year] = max(Date[Year]))))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks alot for trying 🙂 but i tried the formula and it doesn't really work. I would need the seasonality factor for 16, 17,  18, 19, 20 by months and then take the average of each month of the 5 years. This is the seasonality factor i want to create. 

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Please check if this is what you want:

    Seasonality Factor = 
VAR DayAvg_ =
    CALCULATE ( AVERAGE ( Data[revenue] ), ALLEXCEPT ( 'Date', 'Date'[Year],'Date'[Day] ) )
VAR DaybyMonth_ =
    SUM ( Data[revenue] )
RETURN
    DIVIDE ( DaybyMonth_, DayAvg_ )

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.