Forum Discussion

AxlCox's avatar
AxlCox
Helper I
4 years ago
Solved

Using a single slider to filter two different date columns in the same table

Some of the data I work with is essentially a list of tickets with Open and Closed dates.    The data I have, in simple terms, is quantites of tickets. I'm being asked to create a filter (slicer) w...
Need Help
Tips and Tricks
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, AxlCox ;

    Yes, you need to create a separate date table that is unrelated to the original table. Then create two measures respectively to calculate the number of open and closed. I created a simple example with the same principle.

    count = CALCULATE(COUNTROWS('table'),FILTER('table',[open date]>=MIN('slicer'[Date])&&[close date]<=MAX('slicer'[Date])))

    The final output is shown below:

    If not ok ,can you share more scenario or screenshots about  more details?
    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, AxlCox ;

Yes, you need to create a separate date table that is unrelated to the original table. Then create two measures respectively to calculate the number of open and closed. I created a simple example with the same principle.

count = CALCULATE(COUNTROWS('table'),FILTER('table',[open date]>=MIN('slicer'[Date])&&[close date]<=MAX('slicer'[Date])))

The final output is shown below:

If not ok ,can you share more scenario or screenshots about  more details?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.