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

2 Replies

  • 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.