1

Limit dates in a slicer to after the last date selected in a date range filter

I have a calendar-type slicer. When I select a date range representing opening dates during that period, I want another slicer for evaluation dates to show only dates that are on or after the last date selected in the date range. Example:

Date range:
From: 2025-06-01
To: 2025-06-30

Evaluation dates:
2025-06-30
2025-07-01
2025-07-15

3 replies

null
    • VP Product Management
    • Ian_Macdonald
    • 4 wk ago
    • Reported - view

    Hi 

    Can you clarify  a little on what you want to filter on? Do you want to slice the data for all dates between the dates selected in the range plus whatever is selected in the second slicer for dates on or after the last date in the range? Or just filter on the second slicer?

    Thanks,

    Ian

      • Angel_Chan
      • 3 wk ago
      • Reported - view

       

      Hi!

      I have records with opening dates that fall within a selected range. For these records, I performed a criss-cross join (cross join) between the opening dates and the evaluation dates from the slicer, in order to calculate the number of days from when the order was opened to the evaluation date.

      The evaluation dates are defined as the first day of the month, the 15th, and the last day of the month. I’ve applied a condition where the opening date must be less than or equal to the evaluation date.

      Because of this setup, what I want is: when I select a range of opening dates, the available evaluation dates should be greater than or equal to the latest opening date in the selected range.

      For example:

      Date range:
      From: 2025-06-01
      To: 2025-06-30

      In this range, I have records with the following opening dates:
      2025-06-01, 2025-06-15, 2025-06-18, etc.

      What I currently get is:
      2025-06-01
      2025-05-15
      2025-05-30

      What I want to get is (evaluation dates):
      2025-06-30
      2025-07-01
      2025-07-15

      thanks!

    • VP Product Management
    • Ian_Macdonald
    • 3 wk ago
    • Reported - view

    hi 

    I don't quite understand why you are specifying a range of dates when all you are interested in are dates that are equal to or greater than the end date of the range. Surely you just need to specify  a single date, then produce a list of dates equal to or later than the specified date.

    Also, does the date dimension whose elements you want to generate contain all dates or just the evaluation dates?

    Thanks,

    Ian

Login to reply

Content aside

  • 1 Likes
  • 3 wk agoLast active
  • 3Replies
  • 45Views
  • 2 Following