Forum Discussion

MeganLouise93's avatar
MeganLouise93
Regular Visitor
1 year ago
Solved

Need help with Dax IF Calculation

Hi there,   I'm pretty new to Dax, and am trying to get an If statement to work - I have 3 outcomes, and the data in the original field is numbers and blanks.   This is how far I've gotten but I'...
  • johnt75's avatar
    johnt75
    1 year ago

    Try

    Open Vs Effective Date Buckets =
IF (
    ISBLANK ( 'All ServiceNow Data'[Open Vs Effective Date] ),
    "Invalid Effective Date",
    IF (
        'All ServiceNow Data'[Open Vs Effective Date] < 0,
        "Opened Before Effective Date",
        "Opened on/after Effective Date"
    )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

Try

Open Vs Effective Date Buckets =
IF (
    ISBLANK ( 'All ServiceNow Data'[Open Vs Effective Date] ),
    "Invalid Effective Date",
    IF (
        'All ServiceNow Data'[Open Vs Effective Date] < 0,
        "Opened Before Effective Date",
        "Opened on/after Effective Date"
    )
)
MeganLouise93's avatar
MeganLouise93
Regular Visitor
1 year ago

Thank you - Unfortunately this is still returning the error "DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values." ðŸ˜”

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    1 year ago

    Check the type of 'All ServiceNow Data'[Open Vs Effective Date] and make sure it is one of the numeric types, it sounds like it is text at the moment.