Query for duedate <= 5d

Questions & Answers
1

query for duedate <= 5d

2

Hi @AsthaSingh

Welcome to the Community! :100:

The query “duedate <= 5d” would mean that you would like to retrieve issues that have a due date starting from the beginning of time until 5 days from now, right?

If you have the Issue dimension in the Rows section and your report is showing individual issues in the rows, you can select the “Issue Due Date” property from the Measures dimension and use a filter for that column: Time dimension

If you have some other dimension in Rows, you can define a new calculated measure in the Measures dimension with the following formula:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateCompare(
      [Measures].[Issue due date],
      DateParse("5 days from now")
    ) < 0
  ),
  [Measures].[Issues with due date]
)

Let me know if this fits your use case!
Nauris