Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
8 years ago
Solved

30 days

I have a measures "INC Opened" which is the count of incident ticekts opened. I need to write a measure showing "INC Opened  in the last 30 days" that updates every time my data refreshes (nightly) 

I do have a calendar table key

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI bhmiller89,

     

    Try this formula:

     

    INC Opened in the last 30 days = 
CALCULATE (
    [INC Opened];
    FILTER (
        ALL ('Date'[Date]);
        'Date'[Date]
            > TODAY() - 30
    )

    Regards.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI bhmiller89,

     

    Try this formula:

     

    INC Opened in the last 30 days = 
CALCULATE (
    [INC Opened];
    FILTER (
        ALL ('Date'[Date]);
        'Date'[Date]
            > TODAY() - 30
    )

    Regards.