Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

MoM variance

  My data is in this format where there are multiple records under one header. I would need to take MoM for Domestically Chartered Commerical Banks. Please suggest on how I can do this.  
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

My Sample:

Measure:

 

MoM variance = 
CALCULATE ( SUM ( 'Table'[value_in_billions] ) )
    - CALCULATE (
        SUM ( 'Table'[value_in_billions] ),
        DATEADD ( 'Table'[Month], -1, MONTH ),
        'Table'[banks] = "Domestically Chartered Commerical Banks"
    )

 

Result is as below.

 

Best Regards,
Rico Zhou

 

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    MoM variance for July is same in your result. I have calculated month on y axis like this.

     

    MoM_CF =
    var sumoflastmonth =

    CALCULATE(SUM('fred_h8_banking_03132023'[Amt in Bn_CF]), PREVIOUSMONTH('fred_h8_banking_03132023'[Month]),
    ALLEXCEPT('fred_h8_banking_03132023',fred_h8_banking_03132023[series_title],'fred_h8_banking_03132023'[Month]))

    var sumofthismonth =

    CALCULATE(SUM('fred_h8_banking_03132023'[Amt in Bn_CF]), ALLEXCEPT('fred_h8_banking_03132023',fred_h8_banking_03132023[series_title],'fred_h8_banking_03132023'[Month]))

    return DIVIDE((sumofthismonth-sumoflastmonth),sumoflastmonth,0)

    //return divide (ABS(sumofthismonth -sumoflastmonth),sumoflastmonth,0)
     
    I would need to calculate it on x axis.