Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Error: Comparison operations don't support comparing values type Text with Values of Type Number

Hi,    I'm new to DAX and need some help, I'm creating a measure in a tabular cube in SSAS. I need to retreive the LastYearLastWeek data from x column:   LastYearLastWeek:= CALCULATE([x], FILTER(...
DAX
SSAS
Week
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Since the error pointed out that it was a data type issue, could you double check the data type of Time[WeekNumber] and Time[Year] columns? Or, if the expression works with "VALUE" function, the data type of the two columns is indeed text.

     

    LastYearLastWeek :=
    CALCULATE (
    [x],
    FILTER (
    ALL ( Time ),
    Time[WeekNumber]
    = VALUE ( SELECTEDVALUE ( Time[WeekNumber] ) ) - 1
    && Time[Year]
    = VALUE ( SELECTEDVALUE ( Time[Year] ) ) - 1
    )
    )

     

    Then, is [x] a column or a measure? If it is a column, it may need to use SUM, MAX, etc, functions with [x].

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Community Support
5 years ago

Hi Anonymous ,

 

Since the error pointed out that it was a data type issue, could you double check the data type of Time[WeekNumber] and Time[Year] columns? Or, if the expression works with "VALUE" function, the data type of the two columns is indeed text.

 

LastYearLastWeek :=
CALCULATE (
[x],
FILTER (
ALL ( Time ),
Time[WeekNumber]
= VALUE ( SELECTEDVALUE ( Time[WeekNumber] ) ) - 1
&& Time[Year]
= VALUE ( SELECTEDVALUE ( Time[Year] ) ) - 1
)
)

 

Then, is [x] a column or a measure? If it is a column, it may need to use SUM, MAX, etc, functions with [x].

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • AteeqSundhu's avatar
    AteeqSundhu
    Frequent Visitor
    2 years ago

    Hi

    i m trying to extract first X digits out of my ID column of data as

     

    Match-ID = IF('ATL-270524'[NTN-FBR] = 9, LEFT('ATL-270524'[NTN-FBR], 7), LEFT('ATL-270524'[NTN-FBR], 11))
    but this resulted in error as "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."
     
    basically the field "NTN-FBR" is having digits plus "-" dash in few cases that is why i've kept data type of this field as "TEXT"
     
    kindly guide ASAP.