Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to calculate the percentage difference of (Count of Items) between this month and last month?
08-05-2019
10:24 PM
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!
Solved! Go to Solution.
1 ACCEPTED SOLUTION

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-05-2019
10:44 PM
@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
1 REPLY 1

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-05-2019
10:44 PM
@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

Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
07-23-2024 11:55 PM | |||
09-05-2024 07:19 AM | |||
05-30-2024 07:10 AM | |||
06-05-2024 02:43 AM | |||
04-26-2024 09:21 AM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
87 | |
81 | |
53 | |
38 | |
35 |