Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower 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'[...
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!!

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper 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!!

  • ArchStanton's avatar
    ArchStanton
    Icon for Power Participant rankPower Participant
    2 years ago

    Thank you!