% increase or decrease for same months in different years

[Anonymous]

I am trying to get the percentage increase or decrease in revenue of a month from different years: example: % increase or decrease in revenue for May 2020 and May 2021.

I tried using MoM %, but it only compares with the month prior. Is there another measure I could use? Or is there a way I could do this?

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Has your problem been solved? 
According to your description, I create a sample.

Here's my solution, create a measure.

Measure =
VAR _Pre =
    CALCULATE (
        SUM ( 'Table'[Revenue] ),
        SAMEPERIODLASTYEAR ( 'Table'[YearMonth] )
    )
VAR _Diff =
    MAX ( 'Table'[Revenue] ) - _Pre
RETURN
    IF ( _Pre = BLANK (), BLANK (), DIVIDE ( _Diff, MAX ( 'Table'[Revenue] ) ) )

Get the result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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

[VahidDM]

Hi   

The solution depends on how you want to visualize your data and your data model, but you can create something like this:

Measure = 
VAR _CurrentDate =
    MAX ( Table[Date] )
VAR _LastYear =
    YEAR ( _CurrentDate ) - 1
VAR _SameMonthLastYear =
    DATE ( _LastYear, MONTH ( _CurrentDate ), DAY ( _CurrentDate ) )

.

.

.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[amitchandak]

@Anonymous , For last year you can opt for one of these

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))
Previous year Month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth(dateadd('Date'[Date],-11,MONTH)))

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA