Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello everyone,
Have found myself stuck on something that I feel should be fairly straightforward and would appreciate your help. I have the following two tables (both of which are much longer than shown):
All Barcodes
Barcode Ranges
The first table is a list of all barcodes that have been produced. The second table contains the list of production events (with their ID number) and the first and last barcodes that this production event created. I am trying to add a column to the first table that displays the "production_id" for each barcode whenever that barcode falls in the "Last Barcode" - "First Barcode" range that corresponds with that "production_id". I have found some solutions in this forum that allow me to do that if a barcode only relates to one "production_id", but the issue that I have run into is that one barcode can relate to several "production_id" values. If I need to clarify anything or you have any questions, please let me know.
Thank you
Hi @jlhecht ,
As you mentioned above, if one barcode can relate to several "production_id" values, what did you want to show in first table? Show first product id ? Or use "," to combine all product id? If possible, could you please inform me your expected output.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I would like each individual barcode to show up in a row for every production id that it corresponds to. That way if I filter on a specific barcode, it will show all of the production id's that it corresponds to in separate rows. I am also open to a better way to display this info, if you have suggestions. Hope this helps!
Thank you
you need to convert barcode, last barcode, first barcode to whole number.
then try below measure
Column =
MAXX(FILTER('Table (3)','Table (3)'[first]<='Table (2)'[barcod]&&'Table (3)'[last]>='Table (2)'[barcod]),'Table (3)'[productid])
hope this is helpful.
Proud to be a Super User!
Thank you, this is almost what I am looking for. This looks to have provided me with every barcode that a production id corresponds with, but only shows each barcode once. This means I am missing when a barcode corresponds to multiple production id's, which is always the case. To further explain, these production id's are subcomponents that go into a larger assembly, which is represented by the barcode. I need to have traceability for which subcomponents (production id) go into each barcode. Thank you and let me know if you need more info.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |