One quick tip about data modeling. If you find things in your model are not associating right, take a look at your key fields. If you add up the subset ratio percentages of a key in each tables that it is in and it equals 100%, this means there are no matching values. So even though the data model viewer shows them as linked because the fields exist in each table, the values within them don’t. This could be due to formatting or misunderstood key fields.
If you take a look at the example below.
%Date in the Calendar table has 46.5%. While
%Date in the Sales table has 53.4%. This equates to ~100%. So each table has values for
%Date, but none of them exist in the other table.
If you take a closer look, you’ll notice that the date formats are different. This is a simple mistake that can throw off your model entirely.