Calculate the difference between one month and the previous selected month

[AliceW]

Hello ladies and gents,

This is killing me. I have an Amount for each month of the previous two years. I want to calculate the difference between one month and the previously SELECTED month.

Like say the user selects January 2021 and January 2020. The difference should be between these months.

But if the user selects January and February 2021, the difference should be between them.

If the user selects January and June 2021, you guessed it, the difference should be between them.

I know we have PREVIOUSMONTH and SAMEPERIODLAST YEAR. But is there a way to mix them?

Huge thanks,

Alice

[KNP · Accepted solution]

Hi Alice,

I may be misunderstanding, but doesn't SAMEPERIODLASTYEAR do this by itself?

When you say...

Does that mean if the user selects January and June 2021, you want to compare it with January and June 2020?

Like I say, I may be misunderstanding, but I've attached a sample PBIX in case it helps.

Gif below demonstrates what I mean.

[AliceW]

Thank you so much, guys!!

[V-lianl-msft · Accepted solution]

Hi @AliceW ,

Maybe I understand,Please try this measure and refer to the attached pbix.

diff = 
VAR month_1 =
    CALCULATE (
        TOPN ( 1, VALUES ( 'Table'[year_month] ), 'Table'[year_month], ASC ),
        ALLSELECTED ( 'Table' )
    )
VAR month_2 =
    CALCULATE (
        TOPN ( 1, VALUES ( 'Table'[year_month] ), 'Table'[year_month], DESC ),
        ALLSELECTED ( 'Table' )
    )
VAR First_ =
    CALCULATE (
        SUM ( 'Table'[value] ),
        FILTER ( 'Table', 'Table'[year_month] = month_1 )
    )
VAR Second_ =
    CALCULATE (
         SUM ( 'Table'[value] ),
        FILTER ( 'Table', 'Table'[year_month] = month_2 )
    )
RETURN
    Second_-First_

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KNP · Accepted solution]

Hi Alice,

I may be misunderstanding, but doesn't SAMEPERIODLASTYEAR do this by itself?

When you say...

Does that mean if the user selects January and June 2021, you want to compare it with January and June 2020?

Like I say, I may be misunderstanding, but I've attached a sample PBIX in case it helps.

Gif below demonstrates what I mean.