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 my frinds.
i got a problem in my data model design.
i have two tables in whitch there are two duplicated columns.how can I create a bridge table (if is neccesary) to handle this issues?
thanks.
following pictures are a screenshot of those tables
as u see, city codes and years are those two column i've said.
Solved! Go to Solution.
Hi,
Here's an idea. Using Query Editor, append the City column from both datasets and then remove duplicates. Save this new one column table as Cities. Do the same for Years as well. Then create a relationship.
Hi,
Here's an idea. Using Query Editor, append the City column from both datasets and then remove duplicates. Save this new one column table as Cities. Do the same for Years as well. Then create a relationship.
Well, you could create a new column in each, CityYear that combines those values. Then you would just need a bridge table that has all of the distinct values from those columns.
thank u.very creative solution.i've used this for other problem.
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |