Forum Discussion
Problem with dates in connected tables
Look on table view (on Power BI Desktop) and on each fields proprieties. All 3 fields must be equal (date at this case).
Why do you need your table 2? Is it a dimention? If it is, both relationship should be single direction (avoid bi-directional relationship every time you can).
If you need to use some field from table 1 to summarize data from table 3, table 1 looks like a dimenson to table 3, why don't you relate then directly? I'd create a dimension based on this field to link to both tables.
As simple you can keep your model, easier it will be to create your measures and visuals, also you will have better performance on its data refresh and report usage.
As you can see in TABLE 1 key is SVCREATEDBY which have duplicates and it's correct, same thing is in TABLE 2 so i decided to made a TABLE 3 which contains only unique values from both tables.
