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.
Team: I need a way to track when a craft kit has been purchased. For example if someone was buying parts towards a complete kit I would like to be able to have one line item once all the parts are purchased "complete kit". An example of the data would be like below. There is no specific order to buy the parts so I can't even say once (this piece) is purchased it's comple. There could be multiple people buying multiple craft items
Craft | Part | Date Purchased | Customer |
Doll | Head | 11/5/2020 | A |
Doll | Body | 12/19/2020 | A |
Doll | Legs | 1/15/2021 | A |
Doll | Arms | 3/5/2021 | A |
Car | Car Body | 12/5/2020 | B |
Car | Wheels | 2/10/2021 | B |
Car | Doors | 4/1/2021 | B |
It sounds as if you need a master table that contains all parts for each kit. For example, the Doll kit would have four rows in this master table:
Then you could compare, by Customer, the number of distinct parts in the data table to the number of parts in the master table (for that Craft). If the number of parts matches between the tables, then a complete kit has been purchased.
Proud to be a Super User!
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |