Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
109 | |
102 | |
85 | |
78 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |