Create Visual/Table based on searching unique IDs and other filters in a table.

[thmonte]

I'd like to have one date slicer to check the following scenario

1. Filter 1 - Search The Previous Day Selected for all Rows that match shift = "1600-0000"
2. Filter 2 - Search Day Selected for all rows that match shift = "0600-1400" || "0700-1500" || "0800-1600" and Id = Id that is present in Filter 1
3. Return All Rows that have matching Ids in both Filter 1 and Filter 2

date	Id	shift
1/28/2018	10019	0800-1600
1/28/2018	10150	1600-0000
1/28/2018	10252	0800-1600
1/28/2018	10274	0000-0800
1/28/2018	10746	0800-1600
1/28/2018	10802	1600-0000
1/28/2018	11090	0000-0800
1/28/2018	11095	0800-1600
1/28/2018	11545	1600-0000
1/28/2018	11361	0600-1400
1/29/2018	11367	0000-0800
1/29/2018	11448	1500-2300
1/29/2018	11510	0000-0800
1/29/2018	10150	0600-1400
1/29/2018	10802	0700-1500
1/29/2018	11680	0000-0800
1/29/2018	11545	0800-1600
1/29/2018	11694	0000-0800

I'd like to return the following

date	Id	shift
1/28/2018	10150	1600-0000
1/29/2018	10150	0600-1400
1/28/2018	10802	1600-0000
1/29/2018	10802	0700-1500
1/28/2018	11545	1600-0000
1/29/2018	11545	0800-1600

[thmonte]

bump

[v-xjiin-msft]

@thmonte

I’m not quite understand your requirement, there’re several questions:

1. What are the values in your slicer? Text values like “Previous Day”,  “Day” or specific date values like ‘2018-01-29’, ’2018-01-30’? If it is specific date values, then what does “Day” mean in your second filter?
2. In your second filter: Search Day Selected for all rows that match a value(s) in column B AND match unique values in First Filter. When select Day, you want to get all the rows that match a value(s) in column B. What is this a value(s)? And what does match unique values in First Filter means?
3. The shift value is like a range (1600-0000). Then how to decide for example Shift = 1600 or Shift = 0600?

Please kindly elaborate you requirement by sharing us more detailed logic.

Thanks,
Xi Jin.

[thmonte]

@v-xjiin-msft

1. I believe to use the date slicer I'll need a new row generated based on all of the logic with a single date.  All of the dates in my table are actual dates and not text.

2. I guess my logic explanation is pretty bad now that I am re-reading it.

Hopefully this provides more clarification:

I want to have a Date slicer with a single day picker.  What I need to do is based on the day selected check the previous day for all rows that have a shift = "1600-0000" and compare that against all rows that have "0600-1400" OR "0700-1500" OR "0800-1600".  On top of all that I want to show rows that only have an ID in each of those days so for example:

if I selected 1/2/2018 on my date slicer

then

if ID is present on 1/1/2018 with a shift of "1600-0000"

AND

ID is present on 1/2/2018 with a shift of "0600-1400" OR "0700-1500" OR "0800-1600"

then return those rows that match in the table

[thmonte]

Nothing?