Different data types are in Dax

Question

What are the different data types used in Dax

Jaish Mathews · Answer

In Data Analysis Expressions (DAX) the data types define the kind of data that can be stored in columns or computed in expressions. Here are the primary data types used in DAX: 1. Whole Number Represents integers. Example: 1  42  -10 . 2. Decimal Number Represents floating-point numbers (real numbers) with decimal precision. Example: 3.14  -100.25 . 3. Currency Stores fixed decimal numbers with four decimal places of precision. Example: 100.0000  -45.7500 . Primarily used for financial calculations. 4. Date/Time Stores dates times or combined date and time values. Example: 2025-01-01  12:30:45  2025-01-01 12:30:45 . 5. Text Stores text strings. Example: Hello DAX!  12345 (as a string). 6. Boolean Represents logical values: TRUE or FALSE . 7. Binary (Blob) Used internally for certain operations like images or large objects but is not directly accessible or usable in DAX expressions. 8. Blank Represents a null or empty value. Example: BLANK() . Type Handling in DAX DAX automatically performs type conversions in many cases. For instance: Adding a text string and a number might lead to an error but numbers and dates can often be implicitly converted as needed. The result of a division by zero or other invalid operations returns a blank ( BLANK() ). When working with DAX it’s essential to understand these types and conversions to write robust formulas and avoid errors.

Muhammad Imran Ansari · Answer

Hi Kiran The primary data types in DAX include: Integer: Represents whole numbers without decimal points. Real: Represents floating-point numbers with decimal points. Currency: A fixed-point number with four decimal places used for monetary values. DateTime: Represents dates and times. Boolean: Represents logical values: TRUE or FALSE. String: Represents text data. Variant: A special data type that can represent any of the above types depending on the context. For more detailed information on DAX data types you can refer to the following link: https://dax.guide/datatypes/