Forum Discussion
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
4 Replies
qqqqqwwwweeerrrSolution Sage
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])*100once its done you can see the percentage changeDid I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
RegardsPlease 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
yes
