Data Model and Charting

[oldmanraskers]

Hello,

Below is an excerpt from the two tables I have, the first details the dates that items were packed and the second details dates when containers were shipped. Only certain items go into certain containers:

dateTime	item
01/01/2017	BZ8
01/01/2017	CF1
02/01/2017	CS5
02/01/2017	CT7
02/01/2017	EF3
02/01/2017	FG5
03/01/2017	GB3
04/01/2017	GU5
04/01/2017	HB5
04/01/2017	JG7
05/01/2017	KC6
05/01/2017	KH7
05/01/2017	NI1

and

dateTime	container
01/01/2017	CI11
01/01/2017	CI11
01/01/2017	CI11
01/01/2017	CI23
01/01/2017	CI33
01/01/2017	CI11
02/01/2017	CI24
03/01/2017	CI11
04/01/2017	CI23
04/01/2017	CI35
04/01/2017	CI54
04/01/2017	CI14
05/01/2017	CI11

This is an excerpt from my lookup which shows which containers items should be put in:

item	container
11BZ8	CI11
11CF1	CI22
11CS5	CI22
11CT7	CI55
11EF3	CI33
11FG5	CI22
11GB3	CI24
11GU5	CI22
11HB5	CI23

I would like to model this in power BI and I would like the facility to select an item from a list generated from the first table... and then I need to show the number of containers that were dispatched with those items inside. I have tried to make some references between the columns but the best I can get is to display the total nuber of containers shipped on the day the item was packed and not the number of containers shipped based on my selection of item. Any help would be appreciated.

[v-yuezhe-msft]

@oldmanraskers,

What fields do you use to create relationship among the above three tables? And could you please post the expected result based on the above sample data in table format?

Regards,
Lydia 

[Greg_Deckler]

Soo...the first thing I notice is that your "item"s from your first table, BZ8, CF1, etc. do not match your "item"s from your lookup table, 11BZ8, 11CF1, etc. Is that intentional or...? Makes it hard to form a relationship without matches.