Month over Month change

[Jasleen_kaur]

I would like assistance in creating a visual(showing above) and calculating the Twitter impressions based on the information provided in the image. Please help me with this.

[Jasleen_kaur]

yes

[qqqqqwwwweeerrr]

Hi @Jasleen_kaur 

I have used this data set for calcualtion 

two months data.

You need to create these measure for calculation 

Current Month Impersion = CALCULATE(SUM(Sheet1[Impresion]),

YEAR(Sheet1[Date]) = YEAR(MAX(Sheet1[Date])),

MONTH(Sheet1[Date]) = MONTH(MAX(Sheet1[Date])))

previous month =

    var Current_Month = MONTH(MAX(Sheet1[Date]))

    var Current_year = YEAR(MAX(Sheet1[Date]))

    var previous_month = IF(Current_Month = 1,12,Current_Month-1)

    var previous_year = IF(Current_Month = 1,Current_year-1,Current_year)

return CALCULATE(SUM(Sheet1[Impresion]),

        MONTH(Sheet1[Date]) = previous_month, YEAR(Sheet1[Date]) = previous_year)

Change = ([Current Month Impersion]/[previous month])*100

once its done you can see the percentage change

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards

[Jasleen_kaur]

Please guide why you have calculated pervious year!

[qqqqqwwwweeerrr · Accepted solution]

Hi @Jasleen_kaur 
So if lets say if you want to calculate change in the month of jan so last month will be dec so it will year-1 that y it previous year is used