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.

AxlCox's avatar
AxlCox
Helper I
4 years ago

OK - I didnt even think I had to bring measurements into it. I was thinking the date table would just act as the "master control" for the slicer....or can it? I was using filters to have the cards show totals based on the ticket state. If I'm doing that do I even need to use measurements?

 

I was just thinking the slicer would set the "global" date range and all of the other vizual filters would show what I need them to....