6.5 Data Types
Setting correct data types is essential – DAX, sorting, relationships (संबंध) and performance depend on it. Click the icon on the column header or use Transform › Data Type.
| Type | Use for |
|---|---|
| Text | Names, codes, IDs with leading zeros, phone numbers |
| Whole number | Quantities, counts, integer IDs |
| Decimal number | Measurements, percentages |
| Fixed decimal number (Currency) | Money values – 4 fixed decimal places, avoids rounding issues |
| Date / Time / Date/Time / Date/Time/Timezone | Dates and timestamps |
| True/False | Flags such as Is Returned |
Simple bhashet sangaycha tar, fixing wrong types, Indian date formats (Using Locale) and numbers stored as text is covered step by step in Module 7.7–7.8.
Ravindra Bagale's Tip
Type madhli sagalyat jast disnari chuk mhanje letting automatic type detection run and never checking it. It looks only at the first rows, so a Pincode or Order ID can become a number and lose leading zeros. Set types deliberately after cleaning, especially for IDs, phone numbers and money. Bilkul visru naka.