Forum Discussion

anonymous_98's avatar
anonymous_98
Icon for Resolver I rankResolver I
4 years ago
Solved

DAX comparison operations do not support comparing values of type Date with values of type Text

Error Message: DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

 

can you please help me with the same?

  • I have found the solution for this.

     

    here is the piece of code in the DAX code which caused issue.

    before fixing: 

     

            CALCULATETABLE(
                VALUES(Sales[Customer ID]),
                FILTER(
                    ALL(Sales),
                    Sales[Purchase Date] >= _DateBeforeNDays & Sales[Purchase Date] <= _EndOfMonthDate
                )
            )

     

     

    After fixing: 

            CALCULATETABLE(
                VALUES(Sales[Customer ID]),
                FILTER(
                    ALL(Sales),
                    Sales[Purchase Date] >= _DateBeforeNDays && Sales[Purchase Date] <= _EndOfMonthDate
                )
            )

     why the error caused in the first place?

    --> if you see in the first code, instead of using && operator I was just using & operator. and that was the only reason for the error. 

7 Replies

  • I have found the solution for this.

     

    here is the piece of code in the DAX code which caused issue.

    before fixing: 

     

            CALCULATETABLE(
                VALUES(Sales[Customer ID]),
                FILTER(
                    ALL(Sales),
                    Sales[Purchase Date] >= _DateBeforeNDays & Sales[Purchase Date] <= _EndOfMonthDate
                )
            )

     

     

    After fixing: 

            CALCULATETABLE(
                VALUES(Sales[Customer ID]),
                FILTER(
                    ALL(Sales),
                    Sales[Purchase Date] >= _DateBeforeNDays && Sales[Purchase Date] <= _EndOfMonthDate
                )
            )

     why the error caused in the first place?

    --> if you see in the first code, instead of using && operator I was just using & operator. and that was the only reason for the error. 

  • Hello good day

    This dax throws me the error "DAX comparison operations do not support interger comparison values with Text values.Consider using the VALUE or FORMAT function to convert one of the values.

    Could you help me please?

    Thank you

    VALOR DPP =
    IF(AND([TOTAL CUSTOMERS]="A",[TOTAL DAYS]<=30),0.05*[TOTAL INVOICES],
    IF(AND([TOTAL CUSTOMERS]="B", [TOTAL DAYS]<=60),0.01*[TOTAL INVOICES],
    IF(AND([TOTAL CUSTOMERS]="C", [TOTAL DAYS]<=60),0.05*[TOTAL INVOICES],

    "No discount"
    )))
    • anonymous_98's avatar
      anonymous_98
      Icon for Resolver I rankResolver I

      Syndicate_Admin in case TOTAL CUSTOMERS is a number then if you are comparing it with a String "A" which is wrong. also check the data type of TOTAL DAYS, it should be integer.

  • Good day thanks!
    Sure enough, what I did was assign a number to each letter (A, B, C) in a conditional column and it worked.
    I made the formula with SWITCH, but it only evaluates the first correct condition, but the others are assigned the same result of the first condition. Please if you can guide me. Thank you

    SWITCH(
    TRUE(),
    [TOTAL CUSTOMERS]=1 && [Days Difference]<=30, "5%",
    [TOTAL CUSTOMERS]=2 && [Days Difference]<=60, "1%",
    [TOTAL CUSTOMERS]=3 && [Days Difference]<=60, "3%",
    "No discount"
    )






  • Hi, switch does not evaluate all conditions

    GLOOMY CREDIT =
    SWITCH(
    TRUE(),
    [TOTAL DCLIENTES] =1,600000000,
    [TOTAL DCLIENTES]= 2, 750000000,
    [TOTAL CUSTOMERS]= 3, 700000000,
    0
    )

    TOTAL DCLIENTES =
    DISTINCTCOUNT(cupocredito[DCLIENTE]).

    If I do it with sum, I don't do it either.
    TOTAL DCLIENTES =
    SUM(cupocredito[DCLIENTE])

    Thank you

    Thank you