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

 

See the Addition in Red font

 

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

 

 

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

Hi Zubair_Muhammad

 

Thank you or the feedback. When I try the formula with multiple entries for the month it averages every value and over three months. I would like to sum the entire month of data for all customer and the average only on the monthly totals for 3 months? Your assistance will be highly appreciated.

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago
    Hi Norbi,

    Could you paste some data with multiple customers and multiple dates and result you expect?