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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi jch ,

 

Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

 

Or please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Best Regards,
Eyelyn Qin

  • jch's avatar
    jch
    Microsoft Employee
    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.