Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I’m having a crazy “Duplicated” challenge but I’m out of options, I have a list of MLB players stats since early 90's, for each year I have the same player, till they are actif of course, I would like to create a list of unique MLB players to use as dimension table.
I've extracted list of names, handedness and positions attributes: 2 issues where the first can’t be solved because of the second.
Yeah I know… Other options are welcome!
Thx,
Hi @HotChilli,
Thx, I like the "Primary position" suggestion. Add an additional piece of info for player isn't an option.
Grtz,
For Item 2, you need an additional piece of info to make each player unique e.g. birthdate, middle name, height or something. Hopefully you can add it to your data early on in the process and without doing it manually but if that's the way it has to be done, then that's what you have to do.
Item 1 isn't really a problem - it just depends on what you are using the data for. It works as a Fact table, if you want to keep track of the different positions players have. If you want to use it as a dimension table, then use a primary position field or get rid of the positions and remove duplicates.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
99 | |
38 | |
37 |
User | Count |
---|---|
158 | |
125 | |
76 | |
74 | |
63 |