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.
Hello community, I am hoping you can help me.
I have one column in Table A with part numbers, all unique except for a string of 0's afterwards. Those zero's are there because in the source data there is room so that if a new part number is added, it will overwrite that 0.
I have one column in Table B with part numbers, this time duplicating because they represent each shipment the part number is on.
I want to create a relationship between these two tables on the part number column, but since i need the 0's incase new part numbers are added (this is an autonomous report) it will not let me do so since neither column has a unique number.
I am trying to create a bridge table, but am stck. I want to have a new table that combines part numbers from table A and table B, removing any duplicat values leaving me one table that i can then use to create a relationship with.
Solved! Go to Solution.
Hi @Anonymous ,
Please check if this is what you want:
1. Create a calculated table.
Bridge Table =
DISTINCT (
UNION ( VALUES ( 'Table A'[Part Numbers] ), VALUES ( 'Table B'[Part Numbers] ) )
)
2. Create relationships.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Is this problem solved?
Best Regards,
Icey
Hi @Anonymous ,
Please check if this is what you want:
1. Create a calculated table.
Bridge Table =
DISTINCT (
UNION ( VALUES ( 'Table A'[Part Numbers] ), VALUES ( 'Table B'[Part Numbers] ) )
)
2. Create relationships.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be a Super User!
Paul on Linkedin.
Hi @ImkeF - Since both Table A and B contain duplicates... the bridge table would display all part numbers and the one 0 with no duplicates.
That way Table A can have a relationship with Bridge table and,
Table B can have a relationship with the Bridge Table.
hi @PaulDBrown I will try that, thanks!
Proud to be a Super User!
Paul on Linkedin.
Hi @Anonymous
could you please post (link to) sample data?
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
I cannot post the actual data, but here is an example.
Thanks, but I still don't understand the logic. How should your bridge-table look like / where's the many-2-many here?
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |