Forum Discussion

jch's avatar
jch
Icon for Microsoft Employee rankMicrosoft 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.

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
5 years ago

Hey  jch ,

 

create a pbix file that contains sample data, but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data, share the xlsx as well.

 

Regards,

Tom