MoM change with a measure

[Anonymous]

Hi,

Im trying to calculate a MoM change from this variable:

AA WS =

DIVIDE(

    SUM('wallet_share'[Deuda Interna]),

    SUM('wallet_share'[Deuda externa])

)

My approach was the following:

AA WS_1 =

CALCULATE(SUM('wallet_share'[Deuda Interna])/SUM('wallet_share'[Deuda externa]),

DATEADD(wallet_share[Fecha],-1,MONTH)

)

And then:

AA MoM = [AA WS]-[AA WS_1]

However, this doesnt work. Is there an error? Please help.

[v-yuta-msft]

@Anonymous ,

Mesuare minus measure sometimes doesn't work. Could you share some sample data and clarify the expected result?

Regards,

Jimmy Tao

[Anonymous]

Hi,

This is the data:

Year	Month	amount	total amount	percentage
2018	August	$12,223,940,162.80	$256,682,471,312.66	4.76%
2018	September	$12,398,403,638.51	$249,201,281,497.68	4.98%
2018	October	$13,335,632,187.75	$254,938,640,117.02	5.23%
2018	November	$13,257,593,286.08	$271,370,276,657.27	4.89%
2018	December	$13,526,113,348.24	$272,994,377,931.33	4.95%
2019	January	$13,973,302,229.23	$268,551,517,278.73	5.20%
2019	February	$15,389,685,991.45	$288,150,974,563.63	5.34%
2019	March	$15,780,812,442.37	$292,420,018,287.96	5.40%
2019	April	$16,118,617,756.52	$289,750,213,615.55	5.56%
2019	May	$16,283,954,632.74	$288,871,277,307.34	5.64%
2019	June	$16,892,080,720.50	$296,401,707,114.24	5.70%
2019	July	$16,575,910,084.15	$290,215,200,574.59	5.71%

I would like to obtain the MoM change of the percentage.

I use measures because creating columns for this calculation, with the exact same formula, returned extremely different results since it was agreggating per client; therefore, i cannot use column calculations but measure ones.