Re: Filtering results based on dynamic due date

adamnimmo · ‎10-19-2017

Hi All,

I am back again with another hurdle, I am using a Matrix visual for my order management/view, I am attempting to filter a second level row dynamically based on a specific due date on the top level item.

My source data `Incoming Orders`

Item	Receive Date	Model	PO#	Quantity
01077	9/27/2017	00042	PO84	-65
03254	9/27/2017	03844	PO47	-3
01077	10/2/2017	00042	PO84	-165
03670	10/5/2017	01095	PO13	-8
01006	10/9/2017	01036	PO69	-11.43
04640	10/10/2017	04067	PO66	-250
01717	10/12/2017	02882	PO41	-116.12
69388	10/12/2017	04066	PO35	-17
01761	10/12/2017	04071	PO58	-3.72
69388	10/17/2017	04066	PO35	-57
01112	10/17/2017	04068	PO24	-14.91
01205	10/19/2017	01149	PO82	-170
00779	10/19/2017	02961	PO15	-85
00064	10/19/2017	03302	PO19	-7
00861	10/19/2017	03302	PO19	-7
02882	10/19/2017	03844	PO47	-13
03254	10/19/2017	03844	PO47	-20
03843	10/19/2017	03844	PO47	-1
04183	10/25/2017	04182	PO84	-2
04189	10/25/2017	04182	PO84	-3
39269	10/25/2017	04182	PO84	-3
39270	10/25/2017	04182	PO84	-3
00064	11/1/2017	03302	PO19	-9
00064	11/1/2017	03302	PO19	-10
00861	11/1/2017	03302	PO19	-9
00861	11/1/2017	03302	PO19	-10

The current matrix display

Order	        Model	Item		Due Date
OR8675309	00042	01077		10/16/2017 0:00
OR8675309	00042	01077		10/16/2017 0:00
OR8675309	01036	01006		10/16/2017 0:00
OR8675309	01095	03670		10/16/2017 0:00
OR8675309	01149	01205		10/16/2017 0:00
OR8675309	02882	01717		10/16/2017 0:00
OR8675309	02961	00779		10/16/2017 0:00
OR8675309	03302	00064		10/16/2017 0:00
OR8675309	03302	00861		10/16/2017 0:00
OR8675309	03302	00064		10/16/2017 0:00
OR8675309	03302	00064		10/16/2017 0:00
OR8675309	03302	00861		10/16/2017 0:00
OR8675309	03302	00861		10/16/2017 0:00
OR8675309	03844	03254		10/16/2017 0:00
OR8675309	03844	02882		10/16/2017 0:00
OR8675309	03844	03254		10/16/2017 0:00
OR8675309	03844	03843		10/16/2017 0:00
OR8675309	04066	69388		10/16/2017 0:00
OR8675309	04066	69388		10/16/2017 0:00
OR8675309	04067	04640		10/16/2017 0:00
OR8675309	04068	01112		10/16/2017 0:00
OR8675309	04071	01761		10/16/2017 0:00
OR8675309	04182	04183		10/16/2017 0:00
OR8675309	04182	04189		10/16/2017 0:00
OR8675309	04182	39269		10/16/2017 0:00
OR8675309	04182	39270		10/16/2017 0:00

What I am attempting to have it display

Order	        Model	Item	        Due Date
OR8675309	00042	01077		10/16/2017 0:00
OR8675309	03844	03254		10/16/2017 0:00
OR8675309	00042	01077		10/16/2017 0:00
OR8675309	01095	03670		10/16/2017 0:00
OR8675309	01036	01006		10/16/2017 0:00
OR8675309	04067	04640		10/16/2017 0:00
OR8675309	02882	01717		10/16/2017 0:00
OR8675309	04066	69388		10/16/2017 0:00
OR8675309	04071	01761		10/16/2017 0:00

As you may see within the desired results, I am only wanting to return the [Model] & [Item] when the [Receive Date] is less than the due date.

Thank you for your help and let me know what other information would be helpful.

v-caliao-msft · ‎10-20-2017

@adamnimmo,

For the same Iteam and Model, there are multiple reveive date? If one [Receive Date] is less than the due date, and another [Receive Date] is more than the due date, should it be returned? And do you have Due Date column in your table?

Regards,

Charlie Liao

adamnimmo · ‎10-20-2017

I do have a due date column within a [Orders] dataset, as well as a [DateKey] for managing timelines. To answer your question regarding the Model|Item, correct I only want to display those which are `receiving` before the due date of the order.