create a diference between 2 columns (month last month)

[jppuam]

Hello,

i'm trying to create a measure that gives me the variation between values of a month and the month before.

how can i make that measure for the 3 columns that i show on the image,

 

thank you,

JR

[v-yulgu-msft]

Hi @jppuam,

Suppose the fields [PMR] in above matrix is a measure. To get the difference between current month and previous month, please new a measure like this:

last month value =
[PMR]
    - CALCULATE (
        [PMR],
        FILTER (
            ALL ( 'TableName' ),
            'TableName'[Mes]
                = SELECTEDVALUE ( 'TableName'[Mes] ) - 1
        )
    )

Regards,

Yuliana Gu

[jppuam]

Yuliana,

i've post on other message the formulas that i'm using for that calculation....

i dont really understand that formula that i've shown below. can you see my post and analise it ?

thank you,

JR

[jppuam]

Yulanda,

that not quiet what i need, because you're doiing the diferente.

i need in the right column the values of the previous months, to make a variation from the current month versus the month before.

thank you,

JR

[jppuam · Accepted solution]

Yulanda,

i've got it. using the function PREVIOUSMONTH it gives me the values that i've want.

thank you for the help,

JR