Reply
avatar user
Anonymous
Not applicable

How to calculate the percentage difference of (Count of Items) between this month and last month?

How to calculate the percentage difference of (Count of Items) between this month and last month?

 

I want to calculate the no of items in this month and last month and calculate the percentage difference of the no of items. 

 

Any help will be highly apprciated. Thanks in advance!

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

@Anonymous  - You could do something like this, assuming you have a date table:

 

Percentage Difference = 
var last_month = CALCULATE(
    COUNT(yourtable[Item]),
    PREVIOUSMONTH(Date[Date]) 
)
var this_month = COUNT(yourtable[Item])
return DIVIDE(this_month , last_month) - 1
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson

 

View solution in original post

1 REPLY 1
avatar user
Anonymous
Not applicable

@Anonymous  - You could do something like this, assuming you have a date table:

 

Percentage Difference = 
var last_month = CALCULATE(
    COUNT(yourtable[Item]),
    PREVIOUSMONTH(Date[Date]) 
)
var this_month = COUNT(yourtable[Item])
return DIVIDE(this_month , last_month) - 1
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)