Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
SharonCNE
Frequent Visitor

Need a way to roll up data

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

 

CraftPartDate PurchasedCustomer
DollHead11/5/2020A
DollBody12/19/2020A
DollLegs1/15/2021A
DollArms3/5/2021A
CarCar Body12/5/2020B
CarWheels2/10/2021B
CarDoors4/1/2021B
1 REPLY 1
DataInsights
Super User
Super User

@SharonCNE,

 

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:

 

DataInsights_0-1621603368525.png

 

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.