Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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 +.
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
Solved! Go to 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.
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.
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.
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
73 | |
62 | |
61 |