Incidents created more than 30 days ago

I need a filter to Incidents created more than 30 days ago.
I need a filter than show the issues created more than 30 days ago, with dimension time in years.
Someone can help me?

Hi @Antuan,

The actual solution highly depends on what you want to display.
​If you only want to display the number of issues with issue type “Incident” that were created more than 30 days ago from now, you might use the following expression.

Sum(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,
    [Issue].[Issue]),
   DateCompare(
--issue created date
    [Measures].[Issue created date],
--date to compare with
    "30 days ago"
    )<0
  AND
  ([Measures].[Issues created],
--hard-coded filter on issue type Incident
   [Issue Type].[Incident])>0
  ),
  [Measures].[Issues created],
)

​This includes a hard-coded filter for Issue type.

​Please provide more details of what and how you want to display the results to suggest a better solution for you.

​Regards,
​Oskars / support@eazyBI.com