Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

Error msg on 'CONTAINSROW'what does it mean ?

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#M901634   After convert the date field from text to date , i ...
Need Help
  • hnguy71's avatar
    hnguy71
    4 years ago

    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.

hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
4 years ago

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.