current month minus previous month in matrix

[elimey]

I have a matrix that looks like this:

How can I create another one, in which the value for the current month is equal to the current month - the previous month.  
It means, for example for 30.04.2021 we should have 534-413.

I have used a measure like this:

VAR __PREV_MONTH =

        CALCULATE(

            SUM('Table'[Value]),

            DATEADD('Table'[DSS_START_DATE], -1, MONTH)

        )

    RETURN

    SUM('Table'[Value]) - __PREV_MONTH

But it just works for the last month, i.e. 31.07.2021. For the rest, it shows the same values. 

can someone help?

[v-jingzhang · Accepted solution]

Hi @elimey 

You can add a MonthEnd column to Date table, then use this MonthEnd column in the Matrix as Column field. Then use measures

Previous Month Value = CALCULATE(SUM('Table'[Value]),DATEADD(Dates[Date],-1,MONTH))

Diff = SUM('Table'[Value]) - CALCULATE(SUM('Table'[Value]),DATEADD(Dates[Date],-1,MONTH))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@elimey , You should always use date table, marked as date table , joined with date of you table  , month year should be use from date table

VAR __PREV_MONTH =
CALCULATE(
SUM('Table'[Value]),
DATEADD('Date'[Date], -1, MONTH)
)
RETURN
SUM('Table'[Value]) - __PREV_MONTH

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI : https://youtu.be/OBf0rjpp5Hw

[elimey]

with date table I get the same result: 

As you can see in the picture above, it just affects the last column, i.e. 31.07.2021, not the rest of the columns.