Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |