topic Re: Previous Month in DAX Commands and Tips

Previous Month

ArchStanton — Wed, 10 Jul 2024 10:57:03 GMT

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 — Wed, 10 Jul 2024 10:59:39 GMT

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 — Wed, 10 Jul 2024 11:57:53 GMT

Thank you!