Best way to allocate stock to a kit - Formatting question about options

[RichardJ]

Hi,

I have parts produced in an spordaic sequence and these parts get grouped into Kits.

The Parts in the example are numbers Part 1, Part 2..... Part 10. 
A Kit comprises of one of each Part, so Part 1, Part 2..... Part 10 equals 1 Complete Kit.

Ive been attempting to create this view 

Desired view

I can get a view of Parts available per Kit or

Parts available by Date

the challenge i'm having is getting the view above which shows that I may have produced two kits on a Monday called Kit 1 and Kit 2 and wondered if it's possible to surface them in a visual that shows both the Date and the kit numbers for that day.

The bottom table in the screengrab does this but it's not very aesthetic as it requires the user to expand the +.

Progress

I may be overthinking this - the exam question is to find and show the user the 'number of complete kits' produced on a specific day, and if there are any missing parts make it simple for the user to show which part(s) are missing from the kit.

The first available part(s) should be allocated to the first available kit slots that are short of the Part Number (this is what I was trying with the sub-index to get the allocated Kit Number for each Part Number).

If theres a simpler way of doing this, or if anyone can suggest a better approach please can you let me know.

The pbix can be found here.

https://www.dropbox.com/s/41sp7bt7d88ui0s/Allocating%20Stock%20to%20a%20kit%20question.pbix?dl=0

Thanks

[RichardJ · Accepted solution]

Hi @v-zhangti - Thanks for taking the time to  respond and for pointing that out. I ended up using a different approach to resolve the issue.

[v-zhangti]

Hi, @RichardJ 

Can you share your own solution to help others find it?

Best Regards

[v-zhangti]

Hi, @RichardJ 

I found that the Date format in your file is text, do you need to convert to date format.

Wouldn't this be more in line with your desired outcome?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.