Single date filter to filter two date ranges in the table

DAX DAX Calculations
1

Hello
I have a requirements where single date filter should be able to filter the date range in a table where the date from calendar table as selected value should check the source table and count employees where the selected date filter from the slicer is Less than equal to Adj Hire date and selected date is GT the term date in the source table

example : If user select 12/31/2020 the selected value count all the employees who have adj hire date less than equal to 12/31/2020 and all employees who have terminated date Greater than 12/31/2020
Count according to application is 5073 (for validation)

Any other suggestions also welcome …

Thank you for the help

image
image788×418 6.91 KB

Test Date Filter to select two date range.pbix (1.1 MB)

2

@ERA965 ,

This should be quite straightforward to accomplish using a disconnected date table and slicer, employing the techniques described in the video below:

Give it a watch, and if you still have questions please let me know.

Hope this is helpful.

– Brian

3

Awesome , it worked … Thanks for the quick response its a great solution

1 Like
4

@ERA965 ,

Great - glad to hear that worked well for you.

Disconnected tables/slicers are magic - I probably use them almost as frequently as live slicers.

  • Brian