Forum Discussion
Solved
Month over Month change
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.
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
qqqqqwwwweeerrr
Solution Sage
Solution SageHi 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
Please guide why you have calculated pervious year!
- qqqqqwwwweeerrr
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
