Previous Month

[ArchStanton]

Hi,

Is it possible to modify this measure  so it gives me the previous month total?

MTD Active Cases = CALCULATE(
    TOTALMTD(COUNT('Cases'[Case Number]),'Cases'[Created On]),
    'Cases'[statecode] = "Active")

Thanks,

[rajendraongole1 · Accepted solution]

Hi @ArchStanton - Can you try below measure to get the previous month total

PreviousMonth_ActiveCases =
CALCULATE(
COUNT('Cases'[Case Number]),
DATEADD('Date'[Date], -1, MONTH),
'Cases'[statecode] = "Active"
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[ArchStanton]

Thank you!