Forum Discussion

aditya_141228's avatar
aditya_141228
Icon for Helper I rankHelper I
2 years ago

Find the count for last month

I want to create a new donut chart which displays count of rating for Critical, High, Medium, Low and not related. The column that will be used is rating and it has values Critical, High, Medi...
Need Help
aditya_141228's avatar
aditya_141228
Icon for Helper I rankHelper I
2 years ago

Yes that's exactly what I want to do, a month slicer will be there and I want the count of rating in the second donut which will give me the data of the previous month.

Anand24's avatar
Anand24
Icon for Super User rankSuper User
2 years ago

aditya_141228 ,
Use this DAX in a new calculated measure and pull it into your donut chart:

Previous Month Count =
CALCULATE(
    COUNT('Master Sheet (2)'[Rating]),
    DATEADD('Date'[Date], -1, MONTH)
)

Result: