Forum Discussion

norbi's avatar
norbi
Icon for Helper I rankHelper I
8 years ago

Measures for Customer Trends

Hi, I would appreciate assistance in solving the percentage Month on Month (MoM) growth, percentage Year on Year (YoY) growth and percentage of 3 month average. Below is the table where the input is...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi norbi

 

Try this Measure for MoM

 

MoM =
DIVIDE (
    SUM ( TableName[Vol] ),
    CALCULATE (
        SUM ( TableName[Vol] ),
        FILTER (
            ALLEXCEPT ( TableName, TableName[Name] ),
            TableName[Date] = PREVIOUSMONTH ( VALUES ( TableName[Date] ) )
        )
    )
)
    - 1
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    norbi

     

    This Measure for YoY

     

    YoY =
DIVIDE (
    SUM ( TableName[Vol] ),
    CALCULATE (
        SUM ( TableName[Vol] ),
        FILTER (
            ALLEXCEPT ( TableName, TableName[Name] ),
            YEAR ( TableName[Date] )
                = YEAR ( SELECTEDVALUE ( TableName[Date] ) ) - 1
                && MONTH ( TableName[Date] ) = MONTH ( SELECTEDVALUE ( TableName[Date] ) )
        )
    )
)
    - 1
    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Icon for Community Champion rankCommunity Champion
      8 years ago

      norbi

       

      Final one

       

      % of 3 month_average =
DIVIDE (
    SUM ( TableName[Vol] ),
    CALCULATE (
        AVERAGE ( TableName[Vol] ),
        DATESINPERIOD ( TableName[Date], SELECTEDVALUE ( TableName[Date] ), -3, MONTH )
    )
)