Date Filtering Question

[Jim_]

Hi All,

I have been needed for sometime to be able to filter by a universal date, I thought that "Mark custom date table" was going to be that solution but I don't see how to make it work for my data.  Below is a hyper simplified example of my data:

Widget Lot ID	Date Ordered	Date Produced	Date Dispotioned	Disposition	Date Shipped
W#1	1-Jan-18	2-Jan-18	3-Jan-18	Accepted	8-Jan-18
W#2	1-Jan-18	3-Jan-18	5-Jan-18	Accepted	13-Jan-18
W#3	15-Jan-18	18-Jan-18	21-Jan-18	Rejected	23-Jan-18
W#4	19-Jan-18	23-Jan-18	23-Jan-18	Accepted	28-Jan-18

I would like to be able to have a date filter that could be applied to each date column.  Basically, if I set my filter "04Jan18 to 31Jan18" I want to be able to see what was ordered, produced, dispoitioned, and shipped in that time period.  The new feature only works if you have no gaps and no unique date...I don't have any data that looks like that. 

I know one of you brainiacs will have a solution for me. 

Thanks!!!

Jim

[mattbrice · Accepted solution]

View by Widget Lot ID? I would start by doing some data ETL and unpivoting the date columns so you end up with a 4 column data source, but only one is a 'Date' type:

Widget Lot ID | Disposition Status | Date Type |  Date

W#1     |     Accepted     |    Date Ordered     |  01/01/2018

W#1     |     Accepted     |    Date Produced     |  01/02/2018

...

Then link Calendar table to "Date" column and just put a date slicer on the "Calendar[Date]" column.  Write measures to caculate how many accepted, rejected, etc. 

[Jim_]

Thanks!!!