Forum Discussion

jch's avatar
jch
Microsoft Employee
5 years ago
Solved

Can't determine relationship between fields

I have 2 tables: 1. Table readin contains a calculated field : Actual Date = if(SEARCH("/",readin[Actual], 1, -1) > 1,DATEVALUE(readin[Actual])) 2. Table DimDate contains a date and associated ca...
Need Help
  • jch's avatar
    jch
    5 years ago

    I appreciate your help on this. The answer ended up being

     

    In a one-to-many relationship, you can only filter the relationship by table like table2, but not vice versa.

parry2k's avatar
parry2k
Super User
5 years ago

jch what TomMartens  suggested, but why you are adding DateKey column in Calendar table? What is the type of both the columns? Is it date?