MoM variance

[Anonymous]

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.

[Anonymous]

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]

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.