Help with DAX filtering and slicing

Question

I have a table that contains an Iteration path and its start and end dates.&nbsp; I would like to be able to select one of these iteration paths, and have it filter to the work items that have created or closed dates within that range.&nbsp; Any help would be greatly appreciated!&nbsp;&nbsp;I have included how the tables look below&nbsp;&nbsp;Iteration Path&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Start Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;End Date&nbsp; &nbsp; &nbsp; &nbsp;unit/1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/3/2000&nbsp; &nbsp; &nbsp; &nbsp;unit/2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/4/2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/7/2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;-- Table to select Path&nbsp; &nbsp; &nbsp; &nbsp;unit/3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/8/2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/12/2000&nbsp;Work Item ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Created Date&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/2/2000&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/5/2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/2/2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;-- Table to be filtered&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/3/2000&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/4/2000&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;Work Item ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Closed Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/5/2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/6/2000&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/7/2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;-- Other table to be filtered&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/4/2000&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/11/2000&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

v-chuncz-msft · Accepted Answer

Anonymous&nbsp;
&nbsp;
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single-date/m-p/588265#M278953

Forum Discussion

Help with DAX filtering and slicing

2 Replies

Related content

Slice auto filter

Dynamic filtering/slicing if text contains

Slices /filter filtering

Filter

Slicer not slicing measures with filters