Filter by date in calculated measure

Questions & Answers
1

Hi,

I have been trying for several days to make a report but I can’t!

First you have the name of the customer, then the tickets associated with it. Then you have the two contract increases (software and hardware). Finally, there’s a date.
For each customer, I’d like to display only the tickets that have been ‘Done’ (a green status) in the time interval between now and the date at the far right of the table.

Hope to hear from you!

Xavier

image
image1512×442 35.2 KB

2

Hi @Xavier_Renner

You can achieve this by creating a calculated measure to compare the date when each issue was moved to Done with your custom field

Here’s what you can do:

  1. Create a new calculated measure (in the Measures dimension) with the following formula:
DateCompare(
  (
    [Measures].[Transition to status last date],
    [Status].[Done]
  ),
  [Measures].[Data de renouvellement du contrat] -- Your Custom field Name
) >= 0
  1. Add this calculated measure to your report and set a row filter to show only rows where the result is true
  2. Once the filter is applied and you see only the relevant issues, you can remove this measure from the visible columns—it will still filter the data in the background.

This will show only the tickets that were marked Done before the contract date for each issue.

3

Thank’s for your answer.

Regards
Xavier