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

[Anonymous]

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!

[Anonymous · Accepted solution]

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