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.
My data comes from different sources and in each source the names for my clients are different. So in my fact table name column I could have "Mr John Doe", "Mr J Doe" and "John Doe" but they all represent the same person.
Currently, I have a ClientNameMap table where ClientNameAlias is the primary key which looks as follows:
Key | ClientName | ClientNameAlias |
1 | John Doe | Mr John Doe |
2 | John Doe | Mr J Doe |
3 | John Doe | John Doe |
Then I have an additional lookup table for ClientInfo about the client.
Key | ClientName | City | Company |
1 | John Doe | London | Big Company |
2 | Jane Smith | Miami | Small Company |
Should I relate ClientInfo[ClientName] to ClientNameMap[ClientName] ?
Or should I relate ClientInfo[ClientName] to ClientNameMap[ClientNameAlias]?
In both cases I then relate ClientNameMap[ClientNameAlias] to Sales[ClientNameAlias]
Then I merge Sales with ClientNameMap on the ClientNameAlias column and expand ClientName so that if I want to display a table I can display the official ClientName and not all the different aliases.
Does this make sense? How should I be dealing with the different names for a single client?
Solved! Go to Solution.
I think, judging from what you've shown us. You need to create a relationship between the 2 'Clientname'
The reason you can create a relationship with clientnamealias aswell, is because (in ur example) 1 in 3 have a relation.
With the way you data is set-up though, you might in some scenarios see 'John Doe' three times, so be careful about that.
I think, judging from what you've shown us. You need to create a relationship between the 2 'Clientname'
The reason you can create a relationship with clientnamealias aswell, is because (in ur example) 1 in 3 have a relation.
With the way you data is set-up though, you might in some scenarios see 'John Doe' three times, so be careful about that.
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 |
---|---|
115 | |
100 | |
88 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |