Error msg on 'CONTAINSROW'what does it mean ?

[admin11]

Hi All

I just make a post below :-

https://community.powerbi.com/t5/Desktop/My-Sales-Table-and-Date-Table-unable-to-link/td-p/2545593#M...

After convert the date field from text to date , i get below error :-

Function 'CONTAINSROW' does not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values. OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)).

Hope some one can share with me how to remove the error msg

Paul

[hnguy71 · Accepted solution]

@admin11 ,

You need to change both fields to date. I believe you only changed one side of the table to date. 

Sales[date] must be a date field and DATE[Date] also must be a date field. Set both of those up and you'll be good to go.