cancel
Showing results for
Search instead for
Did you mean:
Member

## MoM change with a measure

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.
2 REPLIES 2
Community Support Team

## Re: MoM change with a measure

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

Regards,

Jimmy Tao

Member

## Re: MoM change with a measure

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.

## Helpful resources

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

#### Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors