Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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.

1 ACCEPTED SOLUTION
Super User

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 4
Frequent Visitor

yes

Super User

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

Frequent Visitor

Please guide why you have calculated pervious year!

Super User

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

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors