Forum Discussion

varelapablo90's avatar
varelapablo90
Icon for Helper II rankHelper II
3 years ago
Solved

IF between DATEs return a TEXT values, how?

Hello community   I am having the below issue: DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to conve...
condition
dates
DAX
if
Text
  • johnt75's avatar
    johnt75
    3 years ago

    You're using & which is the concatenation operator, you need to use && which is logical AND.

    HUB_Scope =
IF (
    T_[Clearing Date] >= RELATED ( T_Mapping[Start Reporting] )
        && T_[Clearing Date] <= RELATED ( T__Mapping[End Reporting] ),
    RELATED ( T_Mapping[HUB_SCOPE] ),
    "NON SCOPE"
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You're using & which is the concatenation operator, you need to use && which is logical AND.

HUB_Scope =
IF (
    T_[Clearing Date] >= RELATED ( T_Mapping[Start Reporting] )
        && T_[Clearing Date] <= RELATED ( T__Mapping[End Reporting] ),
    RELATED ( T_Mapping[HUB_SCOPE] ),
    "NON SCOPE"
)
  • varelapablo90's avatar
    varelapablo90
    Icon for Helper II rankHelper II
    3 years ago

    Oh my... thank you very much ğŸ˜Š