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.
New to data modeling - I did try to search this but it's such as simple question I couldn't find a post.
My data has Patient Name (Text), but also "Medical Record Number" "Account Number" "Transaction ID" "CPT Code" "Modifier" etc.
All those are strings of numbers from 2 to 12 digits long. I can't imagine needing to sum() min() max() these numbers - they basically serve as identification digits, not a number I would want to perform calculations on. They are digits I'll want to aggregate and filter on though.
Are there best practices on how to handle these? Keep them as numbers because there is some background DB optimization reason to do so? Convert them to Text because thats technically how they are used and this avoids other issues?
Same for things like Zip code?
Solved! Go to Solution.
Hi @jjkmd
The simple answer is, everything that you are not performing any aggregations on can be set as data type text, it will make your life easier when you are bringing any of this column to your visual, by grouping them rather then agregating as default behaviour, performance or size of the model is not affected, as it would be in different types of DB's like SQL for example.
Hi @jjkmd
The simple answer is, everything that you are not performing any aggregations on can be set as data type text, it will make your life easier when you are bringing any of this column to your visual, by grouping them rather then agregating as default behaviour, performance or size of the model is not affected, as it would be in different types of DB's like SQL for example.
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.