Different data types are in Dax

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.