Measure to calculate PREVIOUSMONTH inside CALCULATE with USERELATIONSHIP and filter

[MichaelHutchens]

Hi folks, I'm hoping someone can help. I have a measure below that I'm using to count user ratings:

Count of Positive Ratings =
CALCULATE (
COUNTA ('feedback'[Rated Useful]),
USERELATIONSHIP ('feedback'[Feedback User], 'users'[name] ),
'feedback'[Rated Useful] = "Yes"
)

I'd like to be able to create another '% change of positive ratings last month' measure (using the same COUNTA & USERELATIONSHIP & filter, nested inside a 'CALCULATE') that counts the ratings from 2 months ago.

The 'Feedback' table is linked to a 'Calendar' table via an active 'many to one' relationship, so I presume I'd be using this in conjunction with some sort of 'PREVIOUSMONTH' addition to the above measure? Any help would really be appreciated 🙂

[v-cazheng-msft]

Hi @MichaelHutchens 

Is your problem solved? Could you please provide some sample data without sensitive data if this problem haven't been solved? If you have solved it, could you kindly share the solution?

Best Regards

Caiyun Zheng

[Ashish_Mathur · Accepted solution]

Hi,

Do these measures work?

Count of Positive Ratings in previous month = calculate([Count of Positive Ratings],previousmonth(calendar[date]))

% change over previous month = divide(([Count of Positive Ratings]-[Count of Positive Ratings in previous month]),Count of Positive Ratings in previous month)

Hope this helps.

[MichaelHutchens]

Hi @Ashish_Mathur , apologies for my late reply. This is perfect, thank you so much 🙂

[Ashish_Mathur]

You are welcome.