Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
2 years ago
Solved

Previous Month

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,

 

Need Help
Show and Tell
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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!!

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    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!!